setup rights on the database from client side

[Grant]

I have a form that allows me to create a new database on the server from
client side. I get everything to work except for adding users and assigning
rights to the tables. How do I do that?



Thanks

 

[Dale]

Funny you should ask that, Grant...

Just GRANT them permission. Look it up in BOL.

Of course, you have to create the logins and database users first. This
list is straight out of SQL Server Books Online. A review of these stored
procedures should give you all you need to know.

sp_addrole
sp_addrolemember
sp_adduser
sp_defaultdb
sp_defaultlanguage
sp_droplogin
sp_grantlogin
sp_helpuser
sp_password
sp_revokelogin
xp_logininfo
GRANT

Dale Preston
MCAD, MCSE, MCDBA

 

[Grant]

duh, the answer was right in front of me....

Funny you should ask that, Grant...

Just GRANT them permission. Look it up in BOL.

Of course, you have to create the logins and database users first. This
list is straight out of SQL Server Books Online. A review of these stored
procedures should give you all you need to know.

sp_addrole
sp_addrolemember
sp_adduser
sp_defaultdb
sp_defaultlanguage
sp_droplogin
sp_grantlogin
sp_helpuser
sp_password
sp_revokelogin
xp_logininfo
GRANT

Dale Preston
MCAD, MCSE, MCDBA