Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2011-05-05 : 02:09:53
|
| we got two vulnerabilities as part of our security scan.[Object:dm_exec_sessions] [Granted To:public] [Database:master][Permission:SELECT][Object:sysprotects] [Granted To:public] [Database:master][Permission:SELECT]Just want to know if I revoke the select perimission from public, is there any issue regular SQL server activity? thank you |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-05 : 08:04:37
|
| You might break applications.If you're going to revoke permissions, first you need to determine what permissions are required to keep your apps running. |
 |
|
|
|
|
|
select permission to public