Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8068 Views
- Cognizant, I also Faced
- E-Mail Answers
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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different types of indexes available in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
What is the default port no on which sql server listens? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What would you do with an "in-doubt" distributed transaction?
How would you best determine why your MVIEW couldn't FAST REFRESH?
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 are statistics, under what circumstances they go out of date, how do you update them?
What is the difference between clustered and non-clustered index? : sql server DBA
What purpose does the model database server? : sql server DBA
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
what is asm?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
