Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    4

    Unanswered: adding new loggin in ASE 12

    Hello,

    I'm triing to add new loggin to the ASE 12.0, that can only do select from specipc db.
    I used the sp_addloggin and the sp_adduser to the db.

    What more should I do ?

    Tahnks.

    Yaniv

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You should set the default database for that login to the desired database and give the user select permission on the objects.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Mar 2006
    Posts
    25

    Unhappy

    After Creating login u should set the default database using

    sp_defaultdb login_name,db_name


    Quote Originally Posted by shonil
    Hello,

    I'm triing to add new loggin to the ASE 12.0, that can only do select from specipc db.
    I used the sp_addloggin and the sp_adduser to the db.

    What more should I do ?

    Tahnks.

    Yaniv

Posting Permissions

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