setup rights on the database from client side

  • Thread starter Thread starter Grant
  • Start date Start date
G

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
 
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
 
duh, the answer was right in front of me....




Dale said:
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
Click to expand...
 
Back
Top