MSSql7: Alter Table

[tang]

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.

[JHausmann]

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).]

[tang]

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

[JHausmann]

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).]