OraFAQ Forum: Security » Read-only schema with acces to package code

Home » RDBMS Server » Security » Read-only schema with acces to package code

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

Read-only schema with acces to package code [message #248104]

Thu, 28 June 2007 01:34

nuwandee
Messages: 2
Registered: June 2007

Junior Member

Hi,

I have a requirement to implement a read-only schema, that has select access on table objects, but gives read-only access to store procedures / packages code.

Is there any way that I can achieve this.

Thanks.

Report message to a moderator

Re: Read-only schema with acces to package code [message #248112 is a reply to message #248104]

Thu, 28 June 2007 01:51

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

Senior Member
Account Moderator

Quote:

gives read-only access to store procedures / packages

This is meaningless, you execute a procedure you don't read it.

For the rest: just give select privilege then it can't do anything else.

Regards
Michel

Report message to a moderator

Re: Read-only schema with acces to package code [message #248121 is a reply to message #248112]

Thu, 28 June 2007 02:10

nuwandee
Messages: 2
Registered: June 2007

Junior Member

Thanks for your prompt response.

Actually, my requirement is in a development env, where DB access has to be released for testers cum developer, who can check the logic but not to modify the code.

Hope I made it clear.

Report message to a moderator

Re: Read-only schema with acces to package code [message #248147 is a reply to message #248121]

Thu, 28 June 2007 03:04

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

Senior Member
Account Moderator

Do not grant them "create any procedure" privilege.

Regards
Michel

[Updated on: Thu, 28 June 2007 03:04]

Report message to a moderator

Previous Topic:	see users logging in
Next Topic:	DDL auditing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 20:07:26 CST 2024