SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY
PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT
PRIVILIZES.
Answer Posted / 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 |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
what do you understand by flashback feature of oracle?
What is dbcc? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you get actual data change values from previous transactions in oracle?
Explain about your sql server dba experience? : sql server DBA
what are the types of connection load-balancing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is grd?
what functionality does oracle provide to secure sensitive information?
How to start SQL Server in minimal configuration mode?
what is the use of recording information about current session?
what do you understand by fine-grained auditing?
What is replication? : sql server DBA