UserPermissions

Hi,

 

I have one requirement regarding  users  permissions.

I have a development database which developers use to experiment with various
Visual Basic applications they write. As they write these apps, I go in and
manually set the necessary permissions for these apps to work. So,I have to
create userinterface  for giving permissions to users. Means if we select one
user from database using this query. select * from dbo.sysusers.

from this query i have to select one user. when i click the button after
selecting the user according to that particular user all userroles permissions
will assingn for selected user and the permissions evolve over the design and
testing of the application. 

if anybody knows how to do this in asp.net please let me know?

Maybe this link useful for you

http://www.sommarskog.se/grantperm.html

 I think we can do it, if we use current sp that available in SQL Server,

 Hope it helps,

Near