Privileges/Owner of schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Privileges/Owner of schema

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Posts
    1
    Hi guys,

    New to this forum - hoping you can help out !

    Can stored procedures that are stored in one schema access other tables in another schema !

    Thanks

    Parampreet

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    Yes they can - but the owner of the table must grant the required privleges to the owner of the other package/procedure.

    You can then reference the table as .

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    Yes they can - but the owner of the table must grant the required privleges to the owner of the other package/procedure.

    You can then reference the table as owner.object

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Hi you can grant execute privilege on a perticular procedure to any user like this...
    GRANT EXECUTE ON procedure_name TO user;
    This should be given by the owner of the procedure/package who created this procedure/package.
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  5. #5
    Join Date
    Feb 2001
    Posts
    180
    Maybe some text missed in the answer of Jovery

    It should be:
    You can then reference the table as schema.table_name.

    But keep the next points in mind:
    It is a good habit that only procedures etc. in the same schema as the table can modify the table, so grants to other schema_owners can be limited to select on the table and execute on the procedures.
    When you like to modify a table out of another schema,
    you have to grant INSERT/UPDATE to another schema_owner.
    That may cause a leak in security.



    Regards
    Ben de Boer

  6. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  


Click Here to Expand Forum to Full Width