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
How do you open a cluster administrator? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is a user-defined lock?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is dcl? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Why would you call update statistics? : sql server DBA
What is fill factor? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how does an oracle clusterware manage crs resources?
how can you enable flashback feature?