Does anyone have a script or set of privileges that can be granted to a developer and another as an application user, which includes executing stored procedures, etc. I am having difficulty getting the right object privileges and system privileges being granted by the right grantor to work.
Sorry, but no one can give you a script. The grants are going to be "execute" for every "schema.procedure/package" to a particular "user".
All you need to do is grant the execute privilege on the procedure to the appropriate users.
I would say that this is impossible to generalize since it depends on your application ! Only the application developer know what stored procedures, tables etc exist and which users need to access them.
If you're getting a specific error, it might be better to post the details of that. One thing to bear in mind is that, if you use roles to give access to certain tables, users won't be able create any objects which make use of those tables. For example, a user will be able to select from a table but if they try to create a view or stored procedure, they will get a confusing message along the lines of "Table or view does not exist".
Hi, 27th April 2001 19:59 hrs chennai
If you feel hard to understand and give priviliges go to
Oracle Enterprise manager.Use the security manager .It is very easy to handle tool.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width