Solved

grantor-grantee (dbo-public) significance

Posted on 2010-11-23
6
508 Views
Last Modified: 2012-05-10
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
Comment
Question by:anushahanna
  • 3
  • 3
6 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34204152
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
 
LVL 6

Author Comment

by:anushahanna
ID: 34204196
>>This is dependant upon how the model database is set out.

you mean the permissions that PUBLIC role has?
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 500 total points
ID: 34204207
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 6

Author Comment

by:anushahanna
ID: 34205051
got it-thanks.

also, in other words, grantor(dbo) always has more previledges/authority than grantee(public), right?
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 500 total points
ID: 34205121
No not necessarily. The grantor is just the database user that granted the permission. Nothing more.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34205209
OK- but in terms of public and guest, only dbo (or sysadmin) can grant it to them?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now