How to find out what privileges a user currently has in oracle?

Question Posted / lokendra singh

How to find out what privileges a user currently has in oracle?..

Answer / abc

Select * from user_sys_privs;

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How data locks are respected in oracle?

What are the set operators union, union all, minus & intersect meant to do?

What is the simplest tool to run commands on oracle servers?

How to call a stored procedure inside a trigger? Give an example.

pls explain connect by prior with example and its real time use

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

How do I learn what codesets are available in oracle?

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

What are the four Oracle system processes that must always be up and running for the database to be useable?

What happens if the imported table already exists?

How do I recompile a procedure in oracle?

What are the uses of Rollback Segment ?

For more Oracle General Interview Questions Click Here