How to check database is having guest user or not Sybase

If we add login to ASE means, login can only access to master and tempdb. If user wants to access the ‘xyz’ database without adding user, alternative way is guest user. If the user database is having guest user, then login can access the database with the permissions of the guest user.

How to add guest user to the database ‘xyz’

use xyz
go
sp_adduser guest
go

How to check database is having guest user or not Sybase

use xyz
go
hp_helpuser
go

How to check database is having guest user or not Sybase

or

If we add guest user to model database, all databases created subsequently will contain a guest user.

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools