SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.

Question Posted / bazzu

4 Answers
8335 Views
Cognizant, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE ..

Answer / suman

we have to create any user in system level By default we
have 8 prives that is
create table
create index
create sysnonims
create view
etc......
sys>desc v$session_prives;

Is This Answer Correct ?

6 Yes

1 No

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE ..

Answer / suman

we have 8 privilizes that is
create index
create views
create synonyms
create tables
create procedures
create triggers
create functions
we can see in db level that is
> desc v$session_privilizes;

Is This Answer Correct ?

5 Yes

0 No

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE ..

Answer / ravindra

Grant Create Session,Resource;

Is This Answer Correct ?

1 Yes

0 No

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE ..

Answer / feroz

creating user at OS level wont get any privileges
question is not clear first of all?
how come a DBA will be able to create a user
we cann't create users at DB2 level

Is This Answer Correct ?

0 Yes

6 No

Post New Answer

More DB Administration Interview Questions

what is a user-defined lock?

0 Answers Oracle,

Explain what partitioning is and what its benefit is.

2 Answers

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

What the different topologies in which replication can be configured? : sql server DBA

0 Answers

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

For more DB Administration Interview Questions Click Here