Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

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
[541 byte] By [AndyBrons] at [2008-2-3]
«« Saving Dataset
»» Designer and the Toolbox
# 1
resolved, someone put him in a group with greater permissions
AndyBrons at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified