"public" role access in SQL Server

Question

Hi, Can anybody let me know that what permission does public have in sql server.

Thanks

Answer 1

By default the public role can't do anything*. Some DBAs will grant the public role additional rights (to see or change data or run stored procs) if they want everyone to have those rights.

* -- Well, almost anything. They can look at some system views and run queries that don't touch any data (like "select 'a'").

To see the specific rights, right click on the role (In SQL 2005 it's Databases > {Your Database} > Security > Roles > Database Role) and select Properties.

Edit: You might also want to check out the server-level public role. Which is at Security > Server Roles > public