| Local schema vs. public schema [message #64944] |
Sun, 14 March 2004 23:45  |
Avi
Messages: 23
Registered: January 2002
|
Junior Member |
|
|
Hi guys,
I need one piece of Information. I am working in an environment where every developer is giving his or her own schema to work. So now I am creating some packages and procedures in my schema. Will they be visible to all other users as well. And If I want to make them visible then what shud be the approach.
and any other point anybody wud like to mention around this concept it wud be gr8.
|
|
|
|
| Re: Local schema vs. public schema [message #64945 is a reply to message #64944] |
Mon, 15 March 2004 03:20  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can make your schema objects visible to others by granting them access.
Example 1, give all DB users (PUBLIC) access to EXECUTE a procedure:
GRANT EXECUTE ON procedure_name TO PUBLIC;
Example 2: give everybody all rights (insert, update, deleted, etc.) on a table:
GRANT ALL ON table_name TO PUBLIC;
BTW: Why did you post this question in the TUNING forum? In future, please post your questions to the appropriate forum!
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
