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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

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

  1. #1
    Alfonso Diaz Guest

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


    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.



  2. #2
    nigel Guest

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


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


  3. #3
    Mike Reilly Guest

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

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




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center