Question Re: Accessing database without database user in sybase. in Technology Q&A

Accessing database without database user in sybase.

Former Member — Wed, 26 Sep 2018 06:29:43 GMT

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 — Wed, 26 Sep 2018 14:56:57 GMT

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

-bret

Former Member — Thu, 04 Oct 2018 13:59:01 GMT

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 — Mon, 08 Oct 2018 06:37:02 GMT

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 .