Home » SQL & PL/SQL » SQL & PL/SQL » Restrictive access to Porcedures
Restrictive access to Porcedures [message #2209] Fri, 28 June 2002 00:23 Go to next message
Dev
Messages: 28
Registered: May 2001
Junior Member
Hello,

I have lot of procedures under one user schema X. The user and pwd for the same is know to all in organisation. I do not the other users to modify the procedure.

How can I do it without removing it from that X schema? Also if I create a proc in DBA schema and grant execute permission to X, I am not able to execute it without giving DBAschema.procname. I want to execute it with just a Procname. Will creating public synonym work.

Replies awaited,
Regards,
Dev.

Report message to a moderator

Re: Restrictive access to Procedures [message #2215 is a reply to message #2209] Fri, 28 June 2002 09:28 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Yes, a public synonym will work and is probably your best option. Since everyone has access to X, creating private synonyms in that schema wouldn't be very secure.

Report message to a moderator

Previous Topic: After Logon Produces No Error even with Raise_application_error
Next Topic: Update a set range in a varchar2 column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 18:23:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.