• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • 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
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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