[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

'public' role & objects

the foll link suggest the query to indicate all the rights granted to public role.
http://www.mssqltips.com/tip.asp?tip=1694

SELECT SDP.state_desc, SDP.permission_name, SSU.[name] AS "Schema" SSO.[name], SSO.[type]
FROM sys.sysobjects SSO INNER JOIN sys.database_permissions SDP ON SSO.id = SDP.major_id
   INNER JOIN sys.sysusers SSU ON SSO.uid = SSU.uid
ORDER BY SSU.[name], SSO.[name]

but there is no where condition to segregate 'public' role - how is the logic derived?

thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
vdr1620Commented:
The public role is a special database role to which every database user belongs. The public role contains default access permissions for any user who can access the database. This database role cannot be dropped.

http://www.mssqlcity.com/Articles/Adm/SQL70Roles.htm#part_3_2
0
 
anushahannaAuthor Commented:
vdr1620, thanks for the definition.

do you see the query above satisfies the objects that have public role with a permission?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now