Security - sp_helpuser

[RobS23]

I need to use the sp_helpuser system sp to retrieve group\role info: How do I go about creating a table from the results of the sp without editing the sp itself - ie. Embed it within another sp?

 

[rajeevnandanmishra]

Hi,

You can use the SPs for datasource directly.
I think you can use following statements in your sp.
----------
create table myTempTable
(username char(10) null, groupname char(10) null,
loginname char(10) null , defdbname char(10) null,
userid char(10) null, suserid char(10) null)

insert myTempTable
execute sp_helpuser

----------

This will help you in the right direction.

 

[RobS23]

Thanks!

Me being too busy and a bit daft I'm afraid!

I just forgot the exec command!