Accessing database without database user in sybase.

[Former Member]

Hi,

Is it absolutely necessary to have database user corresponding to a login user in sybase to access the database?

Is there any other way this can be done?

[former_member188958]

If the database has a "guest" user, then any login can use the database.

https://help.sap.com/viewer/2705a3b1e3df4514ab089cfedf87750d/16.0.3.5/en-US/a91a886cbc2b10148fa3db0a...

-bret

[Former Member]

Thanks for the answer. But if we assign sso_role to the login user, that login user should be able to access all databases?

[tilman_model-bosch]

An ASE login with sa_role will be able to use any database and impersonate any database user.

You can curb the ability of sa_role logins if you enable 'granular permissions' and revoke the 'setuser' privilege.

If an ASE login uses a 'guest' user to access a database it will not be able to do a lot of things in the datbase .