Home » RDBMS Server » Server Administration » info on grants for sequences,procedures & functions
info on grants for sequences,procedures & functions [message #62295] Tue, 13 July 2004 04:58 Go to next message
sara
Messages: 36
Registered: February 2000
Member
where to locate the detail of grants given to following objects.

Grant select on sequence
Grant execute on procedure, function etc

Like we have dba_tab_privs for table level grants.

we are in 9iRAC

Report message to a moderator

Re: info on grants for sequences,procedures & functions [message #62322 is a reply to message #62295] Wed, 14 July 2004 05:13 Go to previous messageGo to next message
shoblock
Messages: 325
Registered: April 2004
Senior Member
Don't know why they never renamed that view (or created a second one with a better name). It contains privs for all object types - not just tables.

Report message to a moderator

Re: info on grants for sequences,procedures & functions [message #62324 is a reply to message #62322] Wed, 14 July 2004 09:27 Go to previous message
sara
Messages: 36
Registered: February 2000
Member
hello ,

thanks for ur update

but i coudn't find any execute privilage in that table i.e (for procedures,functions etc...)

pls help

Report message to a moderator

Previous Topic: How to move a table with a LONG column to another tablespace?
Next Topic: unable to create initial extents
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 07 13:45:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.