Re: sp for User in a Role
From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 11/25/02
- Next message: joe f. haydn: "Access link table security"
- Previous message: Bruce L: "sp for User in a Role"
- In reply to: Bruce L: "sp for User in a Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com> Date: Mon, 25 Nov 2002 21:38:39 -0000
Use the functions IS_MEMBER or IS_SRVROLEMEMBER. See Books Online for more
information.
-- HTH, Vyas, MVP (SQL Server) SQL Server FAQ, articles, code samples, interview questions and more @ http://vyaskn.tripod.com/ "Bruce L" <bruce@Lovingscents.com> wrote in message news:e387d0b3.0211251342.572375bf@posting.google.com... want to create an sp_ that returns true if a user is in a role. found sp_helprolemember, but dont know how to 'exec sp_' inside another sp and see the result set. something like: create proc up_IsUser @User varchar(50), @Role varchar(50) as ???? if user is in role then return 1 ????
- Next message: joe f. haydn: "Access link table security"
- Previous message: Bruce L: "sp for User in a Role"
- In reply to: Bruce L: "sp for User in a Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
