Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • 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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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