guest and public

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
comments powered by Disqus

  « Previous: Next: »