Re: Public Role for SQL 2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 10:15:26 +0000 (UTC)
Tushar (tushar_vaja@xxxxxxxxxxx) writes:
I tried to drop this public role but not able to drop.
I tried to Revoke Select permission but not able to do that. It is not
giving any error but not working as expected. Any urgent reply will be
gratly appreciated.
You could try DENY, but since everyone is in public, this could have
the undesired effect that no one can access anything.
But maybe there is some misunderstanding? Could you clarify more precisely
what tables that are accessible to users who should not get there?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Public Role for SQL 2000
- From: Tushar
- Re: Public Role for SQL 2000
- References:
- Re: Public Role for SQL 2000
- From: Tushar
- Re: Public Role for SQL 2000
- Prev by Date: Re: Help! Set up Windows Group to access application
- Next by Date: Re: Problem with SQL Server 2005 Express Edition
- Previous by thread: Re: Public Role for SQL 2000
- Next by thread: Re: Public Role for SQL 2000
- Index(es):
Relevant Pages
|
