Public role rights

  • SQLGuy64

    Ten Centuries

    Points: 1051

    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

  • Greg Charles

    SSC-Forever

    Points: 45403

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

    Greg

    Greg

  • SQLGuy64

    Ten Centuries

    Points: 1051

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

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

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