Wednesday, March 21, 2012

DB Role and DBO

Hello, I've created a database role for the application user. They are usin
g
the dbo schema, so when I try to add dbo to the role, it won't let me. Why
is this? And does this mean we would need to create some other schema
besides dbo?
Thanks,
MitchHi
DBO is just "special" user. My guess you are using SQL Server 2005 ,right?
In SQL Server 2005 user owner and schema are separeted. You will have to
read BOL on the subject. SCHEMA is juct a container for many objects for
security purposes
"Mitch" <Mitch@.discussions.microsoft.com> wrote in message
news:D29C96D0-AEFA-4263-BA19-D5DE631F2CA9@.microsoft.com...
> Hello, I've created a database role for the application user. They are
> using
> the dbo schema, so when I try to add dbo to the role, it won't let me.
> Why
> is this? And does this mean we would need to create some other schema
> besides dbo?
> Thanks,
> Mitch

No comments:

Post a Comment