How can i select what user(s) have rights on what object ?
please guide!!
Printable View
How can i select what user(s) have rights on what object ?
please guide!!
Query from USER_TAB_PRIVS.
Thanks,
Do not forget inherited privileges, you have to check which ROLES have been granted to the account then check which privileges are granted to the user thru those ROLES.
You may also want to check for system privileges like select any, insert any, etc.
Thanks for shedding more light Paul. Appreciate it.
Thanks,