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

deleted of control file how will u recover control file?

4 Answers CTS,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

What does coalescing a tablespace do?

1 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 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

how to restore files with rman?

0 Answers

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers

For more DB Administration Interview Questions Click Here