Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Ksenia.

Asked: November 01, 2016 - 4:20 pm UTC

Last updated: November 04, 2016 - 2:55 am UTC

Version: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

Viewed 1000+ times

You Asked

Tom,
Could you please tell why in the table ALL_TAB_PRIVS_MADE there are no rows which contains that "I have object privileges for my schema objects"?
I have no admin rights and I know that this table mustn't show this information. But why? (My teacher wants me to give him a quote from oracle docs with explanation why there are no rows about it. I searched this information, but couldn't find it.)

In Oracle Database Security Guide: "A user automatically has all object privileges for schema objects contained in his or her schema." (01.01.2016 - https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1010134 )

SELECT * FROM ALL_TAB_PRIVS_MADE;

| GRANTOR | GRANTEE | OWNER | TABLE_NAME | PRIVILEGE | GRANTABLE | HIERARCHY | COMMON | TYPE |
-----------------------------------------------------------------------------------------------------
| KSEPRO | PUBLIC | SYS | KSEPRO |INHERIT PRIVILEGES| NO | NO | NO | USER |


Thanks,
Ksenia

and Connor said...

Havent you answered your own question ?

"A user automatically has all object privileges for schema objects contained in his or her schema."

Privileges are things you give/grant to other people, or they grant to you. You dont need an explicit privilege on things that you own (ie, in your own schema), hence this is why they do not appear in xxx_TAB_PRIVS.

Hope this helps

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks Tom

Ksenia Prokhorova, November 04, 2016 - 1:24 am UTC

Thanks for answering the question. That really should help.
Connor McDonald
November 04, 2016 - 2:55 am UTC

glad we could help