What is the difference between a sybase database user and login

Is it related to database groups? Login and User - two terminologies which are often confused by the new database developers. What is that credential called which is used to connect to a Sybase server? Is it a Login or a User? To settledown this confusion and give a clear picture to the reader we must first clarify that logins and users - these terms are very vaguely used in computer science every now and then and as far as Sybase is concerned here also we find many people using different terms to specify something else.

For example we will often find developers saying - what is the user id and password for logging into the server. As you can see that the above statement is completly incorrect as user is the person who wants log in to the sybase server however that person uses appropriate credentials to login to the system which is actually a pair of login name aka login and password.

To clarify it further we must know that login's basic purpose is to allow a security check on which ever person or application tries to enter into our Server. Once the correct user has logged in we must try to provide an identity to the login which has connected to our server and hence have a User attached to this Login. The purpose of User is to restrict or allows access to various parts of databases and also for attaching the ownership to the database objects.

Therefore if we do not want to allow certain login to access certain database we can restrict this user by not associating it with an appropriate user id in that particular database. Connect and share knowledge within a single location that is structured and easy to search. After restoring a database from other environment is there a way to map a user in the database to a login in the server.

Sybase ASE does not provide any method for syncing system tables between a user db and the master db. Anyone proceeding with the following steps is solely responsible for any adverse outcomes!! NOTE : sysusers contains data on users, groups and roles; the following applies to the entries for users.

Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 10 months ago. Active 10 months ago. Viewed times. Improve this question. Add a comment. Active Oldest Votes.

Assumptions: db user names are the same as the associated login name ie, sysusers.