Home » RDBMS Server » Performance Tuning » Local schema vs. public schema
Local schema vs. public schema [message #64944] Sun, 14 March 2004 23:45 Go to next message
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 Go to previous message
Frank Naude
Messages: 4565
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
Previous Topic: Oralce Error ORA-04031: unable to allocate 4608 bytes of shared memory ("large pool","unknown object
Next Topic: Tuning Issue Urgent
Goto Forum:
  


Current Time: Sun Sep 20 16:30:36 CDT 2020