Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check privileges of user on tables or other objects

venkatJun 29 2012 — edited Jun 29 2012

Hi Team,

I am a junior Oracle DBA. I am receiving requests from customers like....

1. Provide same privileges for new_USER_ID(A360123) as of existe_USER_ID(A372551).

2. provide same privileges for TABLE_NAME(ex: Employee) as of TABLE_NAME(Ex:DEPT).

My question is.....

How to check privileges of existing user or existing TABLE and how to grant privileges same privileges to new user/new_table.

experts Pls Suggest...

Regards,
Venkat.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2012

Added on Jun 29 2012

#general-database-discussions

5 comments

799 views