Re: Public Role for SQL 2000

Hi, I too have same questions.
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.

Thank,
Tushar Vaja


"wit1" <wit1@xxxxxxxxxxx> wrote in message
news:%23DBcPkqiHHA.1244@xxxxxxxxxxxxxxxxxxxxxxx
For SQL 2000, I see that the Public role has some privileges like SELECT,
UPDATE, DELETE, & EXECUTE, permissions for some User's database objects
(Tables, views, &Stored procedures .)



Is that a security concern?

What will happen if I remove these privileges or revoke them?

Will that effect the rest of the users?



I read many threads on the internet, but no one could tell me the answers
for the 3 questions above.

Thanks in advance.






.

Relevant Pages

  • Re: "REVOKE ALL FROM public" not working
    ... DECLARE @strTableName sysname ... >include things like permission to create a table, a view, ... >The REVOKE ALL only applies to the statement permissions, ... >You could build a script for this by selecting all object ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role for SQL 2000
    ... I tried to drop this public role but not able to drop. ... I tried to Revoke Select permission but not able to do that. ... (Tables, views, &Stored procedures .) ... What will happen if I remove these privileges or revoke them? ...
    (microsoft.public.sqlserver.security)
  • Re: Open letter re: TNT Unicode components redistribution
    ... TW> permission to revoke certain aspects of the original copyright, ... Everything depends on the exact wording of your license, but if you gave the rights to distribute the components in source code, then people can do this without your permission. ... I can see nothing that would let you revoke the previously given permissions. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Ethical dummy?
    ... > specifications whether material or not. ... There is no permission to revoke "when it ... > it can be proved the revoke didn't harm things. ... the opponents can take advantage of it, since they get to name the card ...
    (rec.games.bridge)
  • Re: Dts execution and the public role
    ... Thank you Allan, I put in blank this pivileges for the public role of the ... > When a permission is denied from a SQL Server user or Windows NT user ... The real problem in the public role. ... >> the public role of the msdb DB. ...
    (microsoft.public.sqlserver.dts)