Click to See Complete Forum and Search --> : Changing Permission through programming


navinkaus
May 20th, 2004, 07:39 AM
Hi,
I am making a windows host script in .vbs. I have to change the permission of user and roles through programming in .vbs. How can be done ?
I am using SQL server 2000

hspc
May 20th, 2004, 10:25 AM
check SQL server's Books Online
SQL-DMO topics.
you'll find Grant methods on database/table/view/etc objects...
I'm sorry i can't give more help..I'm not good at DMO.
check this site maybe you find more :
http://www.sqlteam.com