Results 1 to 2 of 2

Thread: login

  1. #1
    Join Date
    Jan 2003
    Posts
    11

    Unanswered: login

    How do i add a login on sybase?
    I did a: select name from sysobjects where type like 'P' on master
    But there doesn't to be many sprocs that can be used to do this? I was guessing that the way to addlogins was similar to MS SQL server, or at least there would be some similar procs?

    thank u

  2. #2
    Join Date
    Mar 2003
    Posts
    15

    Re: login

    Originally posted by dhooper
    How do i add a login on sybase?
    I did a: select name from sysobjects where type like 'P' on master
    But there doesn't to be many sprocs that can be used to do this? I was guessing that the way to addlogins was similar to MS SQL server, or at least there would be some similar procs?

    thank u
    Hi

    you need to use

    sp_addlogin login,password,def_db,language

    most of the system procedures are in sybsystemprocs database like msdb of ms sql server

    after this you can use

    sp_adduser procedure to add that user to perticular database

    if you are very used to ms sql server and windows than you can use sybase central to do al those things using GUI
    db_mate

Posting Permissions

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