Post reply

Granting access to single table

  • December 8, 2003 at 8:48 pm

    #84913

    I have a database used by an off-the-shelf application (JD Edwards). It uses the Public role to grant access to its "system" users.

    I need to give a developer, and eventually, and application access to 1 table in this database. Because of the permissions on the Public role, and because all users must belong to this role, I'm having problems doing so.

    I tried adding him to the Deny roles and then giving explicit permissions to the table (GRANT), but this didn't work. Any ideas? I can't alter the Public role.

    thanks,

    Buddy


    Cheers,

    Buddy

  • December 8, 2003 at 11:37 pm

    #485241

    You should be able to create a role, deny permissions to all tables for the role except the table you want and then do it that way.

    Alternatively you could create a role, assign the same permissions as public, add your JDE users to this role, then revoke permissions to public. the JDE app shouldnt' care.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

  • December 9, 2003 at 7:03 am

    #485313

    Thanks. I was already thinking of doing the "alternative". It would probably be better long run as I won't have to remember to revoke everything for new users/roles.

    Buddy


    Cheers,

    Buddy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply