Problems with roles.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problems with roles.

  1. #1
    Join Date
    Jul 2000
    Posts
    31
    Hi:

    I have a role (LDAP_READ) created that grants select privileges on a certain table (LDAP_OWN.LDAP_ENTRY). I have granted LDAP_READ to a user. When I logon as the user I can describe the table and select data from the table. However in a stored procedure, when the tablename is reference I get the error:

    PLS-00201: identifier 'LDAP_OWN.LDAP_ENTRY' must be declared

    I tried explictly granting select on the ldap_entry table to the user and it appeared to solve the problem.

    Does anyone know what is wrong with my LDAP_READ role?

    Thanks,

    Una.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Create a public synonym on the table.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Stored procedures don't respect roles. You have to grant the priviledges directly.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jul 2000
    Posts
    31

    Cool

    Hi:

    A public synonym actually exists for the table. But I think I found the answer in the Oracle documentation.

    "roles are not meant to be used for application developers, because the privileges to access schema objects within stored programmatic constructs need to be granted directly"

    Thanks.

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