OraFAQ Forum: Security » Please Suggest some privelege

Home » RDBMS Server » Security » Please Suggest some privelege

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

Please Suggest some privelege [message #250630]

Tue, 10 July 2007 13:01

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hello Forum
One of my business user want to see the DDL of tables and indexes, so I granted him 'select catalog'. But with this privilege he is not able to extract DDL for indexes. Then I escalated the privelge to 'select any table'. This solved his problem about extracting DDL for indexes. But this privilege is too risky and he need some privelege between these two.

Can anybody please suggest something

Thanks a lot

Report message to a moderator

Re: Please Suggest some privelege [message #250632 is a reply to message #250630]

Tue, 10 July 2007 13:11

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ask him why does it need this.
I don't see any reason a business user has to see DDL.

Regards
Michel

Report message to a moderator

Re: Please Suggest some privelege [message #250638 is a reply to message #250632]

Tue, 10 July 2007 13:29

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

The tables are often created or modified in that database. So he need to take some dynamic decisions based on that structure.
Thas why he need to see the DDL of tables and indexes.

Thanks a lot

Report message to a moderator