Solved

Access schema objects from another schema's package using a role

Posted on 2008-10-28
2
1,175 Views
Last Modified: 2012-06-27
I created a schema named myconfigs which has 3 tables, a role which has select, update, delete on the three tables named myconfig_user. I have another schema named workuser that has been granted myconfig user role. If I do select * from myconfig.table1 the select statement works. If I put the select statement in a package named workuser.package1.selecttable1 proc I get insufficient privileges.

If I grant select access on myconfigs.table1 to workuser I can create the package. Why doesn't the role give sufficient privileges to access the tables in workuser.package stored procedures?
0
Comment
Question by:mandarins_nyc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 125 total points
ID: 22824390

Packages/Procedures DO NOT recognize role privileges. Yuo have to GRANT those privileges directly to the Package/Procedure owner.
-- OR --
Create package in the schema that owns the tables and GRANT execute on that procedure to the other schema (account).
0
 

Author Comment

by:mandarins_nyc
ID: 22824434
Thanks - this seems exactly what the case is unfortunately I was unable to find it in any oracle documentation.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question