Post reply

Public role rights

  • September 19, 2005 at 11:14 am

    #87827

    I gave a developer rights to the Public role on a SQL Server 2000 database.  The Public role only has explicitly set select rights to the system tables and one user table.  There are no other explicit rights set.  The developer say they were able to open the table in enterprise manager and change data.  Is this possible?

    Thanx for your responses in advance,

    andy

  • September 19, 2005 at 1:12 pm

    #591098

    Are you certain that the developer is not a member of any other database role that may have DELETE permission?

    Greg

    Greg

  • September 19, 2005 at 1:18 pm

    #591103

    you are right. he was in another group with greater permissions.

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

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