Home » RDBMS Server » Security » Read-only schema with acces to package code
Read-only schema with acces to package code [message #248104] Thu, 28 June 2007 01:34 Go to next message
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.
Re: Read-only schema with acces to package code [message #248112 is a reply to message #248104] Thu, 28 June 2007 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Read-only schema with acces to package code [message #248121 is a reply to message #248112] Thu, 28 June 2007 02:10 Go to previous messageGo to next message
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.
Re: Read-only schema with acces to package code [message #248147 is a reply to message #248121] Thu, 28 June 2007 03:04 Go to previous message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Dec 08 06:23:31 CST 2016

Total time taken to generate the page: 0.24003 seconds