i would like to know what is the exact difference between
grant select on table1 to public
grant select on table1 to guest
Subject: public vs guest
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 5 Dec 2012 21:15:46 -0800
X-Trace: forums-1-dub 1354770946 172.20.134.41 (5 Dec 2012 21:15:46 -0800)
X-Original-Trace: 5 Dec 2012 21:15:46 -0800, 172.20.134.41
Xref: forums-1-dub sybase.public.ase.general:31583
Article PK: 1158159
Subject: Re: public vs guest
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
Date: 6 Dec 2012 04:49:04 -0800
X-Trace: forums-1-dub 1354798144 172.20.134.152 (6 Dec 2012 04:49:04 -0800)
X-Original-Trace: 6 Dec 2012 04:49:04 -0800, vip152.sybase.com
Xref: forums-1-dub sybase.public.ase.general:31589
Article PK: 1158169
public is a group.
Every user in the database (not the server, added with sp_adduser to the
inherites the permissions of the public group.
> grant select on table1 to guest
guest is a user.
If a guest user is added to the database, any user in the server
(even those that are not defined in the database) gets the permissions of
guest user, and since that's a user in the database, also the permissions
granted to the
The disadvantage of groups is that a user can only belong to one group in a
What works best for me is using serverwide roles in combination with a guest
the database. Then there is no need to define users in the database and the
their permissions through the roles they belong to.