1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

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  

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

0 Answers  

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,

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

which background process will run @ the time of creation of catalog database

1 Answers   CSC,




Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

How do you tell what your machine name is and what is its IP address?

4 Answers  

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories