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

What privilege is needed for a user to query tables in another schema?

what is the difference between oracle enterprise edition and oracle express edition?

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

State any two functions of oracle?

Can you tell me how to add new column in existing views?how?How is possible?

Explain compound trigger in oracle?

What are the attributes of cursor?

What is the function of Redo Log ?

can we insert any row to dual table if i got the permission from DBA

What is Public Database Link ?

Can we create more than one constraint to column ?

Explain alias?

For more Oracle General Interview Questions Click Here