Adding a “guest” user to a database  “guest” user in user databases

Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

“guest” user permissions

“guest” inherits the privileges of “public.” The Database Owner and the owners of database objects can use grant and revoke to make the privileges of “guest” either more or less restrictive than those of “public.” See Chapter 17, “Managing User Permissions,” for a description of the “public” privileges.

When you install Adaptive Server, master..sysusers contains a guest entry. The installation script for the pubs2 database also contains a guest entry for its sysusers table.





Copyright © 2005. Sybase Inc. All rights reserved. “guest” user in user databases

View this book as PDF