Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8

    Smile Unanswered: How to control MS SQL Server DataBase's permissions through visual basic programing

    Hello,

    Could someone help me to view, add, delete, and modify users of SQL Server DataBase and permissions of them on this database through Visual Basic Programming

    Because I want to do VB application through which I will view, add,delete, and modify users of SQL Server DataBase and their permissions on this database.

    Thank you very very much

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    You can use the system stored procedures.

  3. #3
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8
    Originally posted by rnealejr
    You can use the system stored procedures.
    Thank you very much Mr. rnealejr for your reply.

    Would you like to send me a sample code in visual basic to view ,for example, users of SQL Server DataBase and their permissions????

    I will be thankful

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Which version of sql server are you using 7 or 2000 ?

  5. #5
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8

    To Mr. rnealejr

    Originally posted by rnealejr
    Which version of sql server are you using 7 or 2000 ?
    Hello, Mr. rnealejr
    I use MS SQL Server 2000.
    Also, I have a problem with SQL Server.
    I have about 50 tables and views in an Oracle DataBase and I have tried to translate them to SQL Server DataBases.
    They were translated succefully but there was two problems :
    1- Key constraints were not translated? (i.e. the destination SQL Server database became without primary key and foreign key constraints and aother constraints)
    2- Also, views are translated into tables not into view ??

    Could you slove these problems?

    After I get more information I will be able to serve your good forum with good posts becuase until now I am student

    Thank you very much

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    How did you translate from oracle to sql server ?

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    You can use sp_helpuser, sp_helplogins - use the ado command object.

  8. #8
    Join Date
    Dec 2002
    Location
    UAE
    Posts
    8

    Translating an Oracle DataBase to a SQL Server DataBase with consraints and views

    Originally posted by rnealejr
    How did you translate from oracle to sql server ?
    Yes
    I have used DTS Wizard to do this translation but tables were translated without constraints and also views were translated into tables instead of corresponding views although all tables, from whcih views get data, are available in the translated database.

    Thank you very much Mr.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •