How can i do give all permissions to any user by code

[Alfonso Diaz]

Hi.
I have a database that i need to install to many customers but, i need give
all permissions to the users for they can use my vb application.

[nigel]

I don't understand your question.
a. How many databases/servers will you be using?
b. How many customers are going to be accessing the database(s)/server(s)?
c. Does your VB app need to create database objects? E.g. databases, tables,
users...


"Alfonso Diaz" <adiaz0809@yahoo.com> wrote:
>
>Hi.
>I have a database that i need to install to many customers but, i need give
>all permissions to the users for they can use my vb application.
>
>

[Mike Reilly]

If you wish to do this in code on MS SQLServer, look at the following stored
procedures and SQL statements:

1. GRANT
2. xp_grantlogin
3. sp_addlogin
4. sp_addremotelogin
5. sp_adduser
6. sp_defaultdb
This is all documented quite well in SQLServer books on-line.

There are some others you might want to look into as well
Alfonso Diaz wrote in message <38cfad47@news.devx.com>...
>
>Hi.
>I have a database that i need to install to many customers but, i need give
>all permissions to the users for they can use my vb application.
>
>