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 is an oracle wallet?

Explain compound trigger in oracle?

What is Redo Log Buffer in Oracle?

What happens to the current transaction if the session is ended?

Shall I get Pro*C Compiler in Oracle-10g release ?

What is oracle open database communication (odbc)?

Explain the use of full option in exp command.

i want department wise maxmum salary and empolyee name

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Explain what are the uses of rollback segment?

What is an oracle and why it is used?

How do I manually uninstall oracle client?

For more Oracle General Interview Questions Click Here