23 Nov 2005
guest and public
- guest = valid login but no account
- guest is created (but disabled) by default; to enable run
GRANT CONNECT TO GUEST
- guest gets the permissions of the public role (as does everyone)
- by default public has no permissions
- Northwind: permissions are granted to public
- pubs: permissions are granted to guest