Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to create new user/passwd ?

Status
Not open for further replies.
hoctro

hoctro

Technical User
Joined
Mar 29, 2001
Messages
34
Location
US
Hi

How do I go about to create a new userid and passwd to use the existing database on ase12.0 ?

thanks
 
Sort by date Sort by votes
This is what to do on 11.5, and 12.0 should be similar.

Make sure the user has a server login using sp_addlogin.

Then add the user to the database using sp_adduser

Finally, set the password using sp_password

Greg.
 
Upvote 0 Downvote
Cool..thanks GREG :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question Question
Need help with SQL query to update a Micros report
Replies
0
Views
865
AM_WG
AM_WG
raphael75
  • Locked
  • Question Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
515
raphael75
raphael75
genleo
  • Locked
  • Question Question
Create a new role
Replies
0
Views
251
genleo
genleo
baltman
  • Locked
  • Question Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
567
baltman
baltman
xhan13nyuwe
  • Locked
  • Question Question
Sybase Replication Server - Create user error
Replies
0
Views
284
xhan13nyuwe
xhan13nyuwe

Part and Inventory Search

Sponsor

Back
Top