Public role and explicit rights

Hot Topic

SP1 Installation Failure for Reporting Services Instances
Supporting Multiple Character Sets
How to build application
Return the data from a table ordered by its hierarchy
Activating the Queue
IDW15: DCR: Make precedence constraint editor bigger
Has anyone noticed a size difference between 2.0 and 3.0?
Reefernce dimensions
Getting Started walkthroughs
Update SSIS package in SQL Server Management Studio to reflect recent changes

SQL Server

Case - Sensitive field
How to insert a record in the middle of a DB
SQL Desktop Engine Connection Problel
Analysis 2005 Dimension Max members
Help with using the right approach
table design.. help im stuck!!
WMI Provider Error
Sql Reporting Services problem
list of attached databases
The user 'sa' does not have permission to register endpoint 'sql_endpoint' on the specified URL. Please ensure the URL refers t

Public role and explicit rights

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 was able to open a table that had no rights set in enterprise manager and change data.  Is this possible

What are are the rights in Public if an object doesn't have them explicitly set

Thanx for your responses in advance,

andy

Answer this question

Public role and explicit rights

  • sai81

    resolved, someone put him in a group with greater permissions
  • Public role and explicit rights
Answer this question