231 reputation
413
bio website buddhism.wakayos.com
location United States
age 41
visits member for 5 years, 7 months
seen yesterday

I'm a developer from Takoma Park, MD.

At the office, I work on MSSQL, C#, VB.NET, Javascript, ASP.NET.

At home, I'm a vegan, a sci-fi fan, dabble in foreign languages and enjoy book clubs.

I will try to up vote everyone who answers me and I thank everyone who has freely given me some of their time to answer my various questions.


May
19
accepted Security effects of granting guest access to a database
May
18
awarded  Student
May
18
comment Security effects of granting guest access to a database
I'm actually asking about the default behavior you get when you database in enterprise manager. It seems to always have dbo, guest and public listed and users and roles. However, I've never been able to leverage guest and public to hack into anything as you seem to suggest is possible.
May
18
comment Security effects of granting guest access to a database
In enterprise manager, guest is listed as a user via group membership. EM reports the user doesn't exist when you try to drop it. It is not listed as a member of public. It has no explicit rights on any object. It hasn't been added as an explicit member of any role. Was the public role and guest account created just to create the illusion of complete and utter anonymous access without actually doing so?
May
18
asked Security effects of granting guest access to a database
May
9
awarded  Autobiographer
May
9
awarded  Supporter