Access Privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Access Privileges

  1. #1
    Join Date
    Apr 2001
    Location
    Denver
    Posts
    1

    Question

    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.

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    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.

    Good Luck.

  3. #3
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    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".



  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    USE OEM

    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.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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