I am looking for a script to find out all userid's in a database that have
"dbo" role.Hi Grazyna
dbo is not a role, it is a user and in SQL 2005, it is also a schema.
Do you mean that you want to find members of the db_owner role?
If so, you use the following stored procedure:
EXEC sp_helprolemember db_owner
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Grazyna" <Grazyna@.discussions.microsoft.com> wrote in message
news:31129F0B-2C16-48CE-905B-93803F11D42B@.microsoft.com...
>I am looking for a script to find out all userid's in a database that have
> "dbo" role.|||Thank you. Yes, this is very close to what I need. Thank you very much for
this tip.
"Kalen Delaney" wrote:
> Hi Grazyna
> dbo is not a role, it is a user and in SQL 2005, it is also a schema.
> Do you mean that you want to find members of the db_owner role?
> If so, you use the following stored procedure:
> EXEC sp_helprolemember db_owner
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Grazyna" <Grazyna@.discussions.microsoft.com> wrote in message
> news:31129F0B-2C16-48CE-905B-93803F11D42B@.microsoft.com...
>
>|||I think,I can also modify code used in sp_helplogins to just list me the
users who are members of db_owner role. Thank you for your help.
"Kalen Delaney" wrote:
> Hi Grazyna
> dbo is not a role, it is a user and in SQL 2005, it is also a schema.
> Do you mean that you want to find members of the db_owner role?
> If so, you use the following stored procedure:
> EXEC sp_helprolemember db_owner
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Grazyna" <Grazyna@.discussions.microsoft.com> wrote in message
> news:31129F0B-2C16-48CE-905B-93803F11D42B@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment