• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 717
  • Last Modified:

grantor-grantee (dbo-public) significance

when we see that grantor (dbo) has granted permissions to grantee (public), does this have any significance?

only dbo can grant permission to public, anyways?

and also all permissions to public (the system objects) are granted at the database creation, automatically, right?

thanks
0
anushahanna
Asked:
anushahanna
  • 3
  • 3
3 Solutions
 
EvilPostItCommented:
This is dependant upon how the model database is set out. New databases are created as a copy of MODEL.

With regards to your fist line regarding grantor grantee. This is how the system is built to begin with.
0
 
anushahannaAuthor Commented:
>>This is dependant upon how the model database is set out.

you mean the permissions that PUBLIC role has?
0
 
EvilPostItCommented:
Yes, its what permission the PUBLIC role has in the model database. As upon new database creation these will be copied to the new db.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
anushahannaAuthor Commented:
got it-thanks.

also, in other words, grantor(dbo) always has more previledges/authority than grantee(public), right?
0
 
EvilPostItCommented:
No not necessarily. The grantor is just the database user that granted the permission. Nothing more.
0
 
anushahannaAuthor Commented:
OK- but in terms of public and guest, only dbo (or sysadmin) can grant it to them?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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