OraFAQ Forum: SQL & PL/SQL » UNDER ANY TABLE / TYPE / VIEW

Home » SQL & PL/SQL » SQL & PL/SQL » UNDER ANY TABLE / TYPE / VIEW (Oracle 11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UNDER ANY TABLE / TYPE / VIEW [message #599424]

Thu, 24 October 2013 08:16

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

While conducting security audits of our databases, I noticed that the DBA role has three privileges I've never heard of, let alone used:

UNDER ANY TABLE
UNDER ANY TYPE
UNDER ANY VIEW

I can't find anything in the Oracle documentation or on Metalink about them. Does anyone here know what they might be for?

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599426 is a reply to message #599424]

Thu, 24 October 2013 08:44

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You didn't search very well.
UNDER ANY TYPE/VIEW is in GRANT page
UNDER is explained in CREATE VIEW/TYPE.
This only in SQL Reference Manual.

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599448 is a reply to message #599426]

Thu, 24 October 2013 11:02

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

I should have said "something meaningful". There isn't a lot there. Thanks anyway.

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599452 is a reply to message #599448]

Thu, 24 October 2013 11:32

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is missing?

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599516 is a reply to message #599452]

Fri, 25 October 2013 00:44

Maaher
Messages: 7065
Registered: December 2001

Senior Member

UNDER ANY TABLE is missing. It is in DBA_SYS_PRIVS but it is not documented. But as far as I understand it, it is not used (yet?). I refer to Oracle bug #12980061.

MHE

[Updated on: Fri, 25 October 2013 00:44]

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599519 is a reply to message #599516]

Fri, 25 October 2013 01:20

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I meant what is not meaningful in the documentation about the 2 other ones I mentioned.
I think UNDER ANY TABLE is there for compliance with the standard even if it is not used fot the moment.

Report message to a moderator

Re: UNDER ANY TABLE / TYPE / VIEW [message #599525 is a reply to message #599516]

Fri, 25 October 2013 02:59

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

Thank you Maaher. Much more helpful Smile

Report message to a moderator

Previous Topic:	[SOLVED] Aliases, a lesson learnt
Next Topic:	recurrsion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:56:37 CDT 2024