Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Doubts

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-08-29 : 07:44:25
Jayvel writes "I need to give rights to DB Users thru
VB coding.

I am creating user Run time I want to give him
a System Administrator right thru VB coding


How to go about this??"

SqlStar
Posting Yak Master

121 Posts

Posted - 2003-08-29 : 09:37:11
Hi,

Try to use SQLDMO. I think its possible when use this.

":-) IT Knowledge is power :-)"
Go to Top of Page

dsdeming

479 Posts

Posted - 2003-08-29 : 10:39:45
Have you run this by your dba? Granting sa privileges represents a major security risk.

Dennis
Go to Top of Page
   

- Advertisement -