Re: Which Oracle table has the authorizations definition?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/01/19
Message-ID: <34c37394.28894336@www.sigov.si>#1/1

On Mon, 19 Jan 1998 12:29:36 +0000, Ilidio Oliveira <"ioliv"@inesca.pt(_remove_this)> wrote:

>Hi.
>
>Which Oracle table has the authorizations definition?, i.e., how can I
>analyse which tables a user can access/who may access a certain table?
>(I supose there's a table/view keeping this relationship)
>
>Thanks in advance.

You can have all this information by combining the following data dictionary views:

	DBA_TAB_PRIVS
	DBA_ROLE_PRIVS

If you don't have access to DBA_* dictionary views, check the following:

	USER_TAB_PRIVS
	USER_TAB_PRIVS_MADE
	USER_TAB_PRIVS_RECD
	USER_ROLE_PRIVS

>
>Ilidio Oliveira
>(ioliv_at_inesca.pt)

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Jan 19 1998 - 00:00:00 CST