RE: Question from Assessment
- From: Ken Powers <KenPowers@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 20 Jun 2006 04:57:02 -0700
I wasn't so much looking for the answer as I was looking for someone with
whom I could discuss the question. It helps me refine my reasoning. So your
answer does help me.
"Greg Larsen" wrote:
Based on BOL a “Principal is and entity that can request SQL Server.
resource”. So within the scope of a Database there are three different kinds
of principals: Database User, Database Role, and Application Role. So if you
where to consider the questions to read “Which principal can you assign
permissions to that will replace the permissions assigned to database role,
then the answer would be a Database User and/or and Application Role.
Sorry this doesn't help it only repeats what I said before.
"Ken Powers" wrote:
Here's the entire scenario:
You are the senior database administrator (DBA) for a personnel management
company. You are responsible for Microsoft(R) SQL Server(TM) 2005 database
administration and for training other DBAs.
The company recently upgraded all servers running SQL Server 2000 to SQL
Server 2005. DBAs still use SQL Server 2000 security management methods and
objects when they are available. You have directed them to use SQL Server
2005 security management objects when there is a difference.
DBAs previously used combinations of database roles to manage user rights
assignments.
What SQL Server 2005 security principal replaces database roles?
SQL Server roles
Database users
Database groups
Application roles
Windows groups
My guess is that they want us understand the difference between the old "SQL
Distributed Management Objects" (SQL-DMO) and the new "SQL Server Management
Objects" (SMO). Since I can find no reference to "Application Roles" in the
SQL-DMO, I figure the answer must be "Application Role".
"Greg Larsen" wrote:
I'm not a 100% on whether this is what they are getting at, but by reading
"about principals" in BOL it appears that a "principal" falls into three
different categories: Windows-level, SQL Server-level, and Database-level. A
Database-level principal is one of the following: Database User, Database
Role, or Application Role. So I suppose maybe they are refering to a
Database User and/or and Application Role. Although this are not exactly
replacements, or different kinds of prinicals that rights can be granted to.
"Ken Powers" wrote:
I have been taking the online assessment tests in preparation for the SQL
Server 2005 certification exam. One of the questions does not make any sense
to me:
What SQL Server 2005 security principal replaces database roles?
I wasn't aware that database roles had been replaced. For example, there is
a command in 2005 called "CREATE ROLE" that "creates a new database role in
the current database". I also did a search of Books Online and a web search
onm "replace database role" and nothing came up.
Does anyone know what this question is referring to? Please provide
references to Books Online and / or web articles when responding/
- References:
- RE: Question from Assessment
- From: Greg Larsen
- RE: Question from Assessment
- Prev by Date: Re: sql2k5 security
- Next by Date: Brute Force Attack
- Previous by thread: RE: Question from Assessment
- Next by thread: Brute Force Attack
- Index(es):
Relevant Pages
|
