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
8053 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 add a data file to a tablespace?

3 Answers

What purpose does the model database server? : sql server DBA

0 Answers

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

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

4 Answers Cognizant,

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

What is fill factor? : sql server DBA

0 Answers

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

For more DB Administration Interview Questions Click Here