In SQL Server and Sybase how exactly Server login, Database login
work? what is the different?

"Shawn" <farzan_toronto101 (AT) yahoo (DOT) com> wrote

A login is a 'server-level' thing, with a username and a password. Some
settings are at the 'login' level - like language and default database.

A database login (do you mean database user?) is a 'database-level' thing
with permissions to access tables, execute procedures, etc.

A login can be a user in a number of databases.

Does that help?

Regards,
Simon.

farzan_toronto101 (AT) yahoo (DOT) com (Shawn) wrote in message news:<ab561c63.0408172056.4cca7812 (AT) posting (DOT) google.com>...
When a new login is added to ASE it will add an entry in a system table
with the login name and userid. This is the login name is the server login.
It is used for authentication at the server.

If you are a valide user to ASE it doesn't mean that you are a valide user
to access all the Databases in the server. If you want to access a DB then
you should have the access to the DB. This DB authentication is done using
the DBlogin.

By default the server login and DBlogin are same. i.e. If the DB owner
allows you to access the Database. Your server login name will be added
as the valide user for the DB. You can change the default option. i.e
you can have server login name as "xyz" and dblogin as "abc". This mapping
is taken care by ASE itself.

Hope it is clear to you...

-amarnadh

amarnadh (AT) iitb (DOT) ac.in (Amarnadh Sai) wrote in message news:<135337d.0408240504.198824d8 (AT) posting (DOT) google.com>...
You're confusing yourself when you use the word login to database.
Login typically means you are been authenticated by the dataserver. As
far as database is concern, you grant access/permission to a user or
group.