Printable View
Hi,
I want to grant other user the ability of altering (adding columns to) the table I created through VB code. In MSSql7, I can't find a statement like 'grant alter table on tb_name to public'. Is it possible to do so in sql7?
Any help will be greatly appreciated.
Give sp_addrolemember 'dbcreator', 'NETDOMAIN\username'
a shot (where username=the name of the user connecting). This will give the authority to a single user.
To give the authority to "public", I think
sp_addrolemember 'dbcreator', 'NETDOMAIN\public'
might work.
Am only just investigating it, I have not yet worked with SQL Server 7.0...
[This message has been edited by JHausmann (edited 08-09-1999).]
Thanks, it really works. I think it will only work for sql7 though, since I can not find a store procedure called sp_addrolemember in sql6.5
Roles are a feature new to 7.0
BTW, there are lots of different assigned roles (and you can create your own, too). You might want to take a look at the online help and see if any of the others are beneficial to your needs.
[This message has been edited by JHausmann (edited 08-10-1999).]