Avatar of enrique_aeo
enrique_aeo

asked on 

Assigning Database Principals to Database Roles

Hi experts

i am reading about Assigning Database Principals to Database Roles
but i do not understand this
1. Membership of database roles can only be assigned to database principals (user database or role database).
2. Server principals (login windows) cannot be assigned membership of database roles (dw_owner)
DatabasesMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
lcohan
SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of enrique_aeo
enrique_aeo

ASKER

about this
something is not right with your statement that "Server principals (login windows) cannot be assigned membership of database roles (dw_owner)"

view attached
www.png
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Databases
Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

62K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo