OraFAQ Forum: Server Administration » GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE

Home » RDBMS Server » Server Administration » GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE

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

GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE [message #161384]

Fri, 03 March 2006 11:49

Ivancleber da Silva Neves
Messages: 74
Registered: July 2002

Member

Hello folks,

What grant would allow a user to issue a describe command on any table of an instance ?

I have already tried grant the role SELECT_CATALOG_ROLE and the privelege SELECT ANY DICTIONARY but it did not work.

Thanks an advance

Report message to a moderator

Re: GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE [message #161446 is a reply to message #161384]

Sat, 04 March 2006 05:37

tridentadm
Messages: 142
Registered: March 2006

Senior Member

just a normal SELECT privilege by the owner of the table will do the trick.

Report message to a moderator

Re: GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE [message #161563 is a reply to message #161446]

Mon, 06 March 2006 01:10

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Or issue

grant SELECT ANY TABLE to <this user>;

--Girish

Report message to a moderator

Re: GRANT TO ALLOW A USER ISSUE A DESCRIBE ON ANY TABLE [message #163381 is a reply to message #161563]

Thu, 16 March 2006 09:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And... locked.
Continue in the thread you started in the SQL Experts.

MHE

Report message to a moderator

Previous Topic:	querying out replication error details.
Next Topic:	Restore to diff box rman

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 18:35:04 CST 2025