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
8016 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

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

Give two examples of referential integrity constraints.

2 Answers

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

Where would you look for errors from the database engine?

0 Answers IBM,

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

3 Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 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

What the different types of replication and why are they used? : sql server DBA

0 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here