Very Computer

by **Akshay** » Fri, 29 Jun 2001 04:12:21

can a role be member of another role

by **Narayana Vyas Kondredd** » Fri, 29 Jun 2001 04:23:44

Yes!
--
HTH,
Vyas
Visit my site for Replication FAQ, Code samples, Database Interview
questions,
Database naming conventions, Database programming guidelines,
Interesting articles, Links and much more at:
http://vyaskn.tripod.com/

can a role be member of another role

by **Akshay** » Fri, 29 Jun 2001 06:06:09

I am sorry what I meant was add a role to fixed server roles. like add a
user defined role to sysadmin

> Yes!
> --
> HTH,
> Vyas
> Visit my site for Replication FAQ, Code samples, Database Interview
> questions,
> Database naming conventions, Database programming guidelines,
> Interesting articles, Links and much more at:
> http://vyaskn.tripod.com/

> can a role be member of another role

by **Dejan Sark** » Fri, 29 Jun 2001 14:44:09

Quote:> I am sorry what I meant was add a role to fixed server roles. like add a
> user defined role to sysadmin

No, only logins are members of the fixed server roles.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.

by **Larry Mosle** » Sat, 30 Jun 2001 04:46:13

Fixed roles are unchangeable, unnless someone knows a hack?

> I am sorry what I meant was add a role to fixed server roles. like add a
> user defined role to sysadmin

> > Yes!
> > --
> > HTH,
> > Vyas
> > Visit my site for Replication FAQ, Code samples, Database Interview
> > questions,
> > Database naming conventions, Database programming guidelines,
> > Interesting articles, Links and much more at:
> > http://vyaskn.tripod.com/

> > can a role be member of another role