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" <no****@nospam.com> wrote in message
news:en**************@TK2MSFTNGP11.phx.gbl...
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