May 18, 2009 at 7:14 am
what is the use of below three users what is the use..can someone Please tell me
guest
sys
INFORMATION_SCHEMA
Regards
Swayambhu
May 18, 2009 at 7:42 am
"Guest" user account has been there since SQL 6.5 days. It was used in SQL 2000 for some system functions and needed to be maintained for SQL to function properly. In some cases it can be considered as a threat. If u think this account is not being used, after u dig deeply in ur SQL server 2005 u can revoke permission from this account.
"sys" is a reserved schema name in SQL server 2005
Information Schema is an ANSI specification for obtaining metadata. They are used to get information about physical aspects about a database such as table, column etc. etc.
May 18, 2009 at 8:37 am
You can remove the guest user. DO NOT remove the others.
May 18, 2009 at 9:16 am
Why I will keep these two..? what is the conceptual use os these users
Regards
Swayambhu
May 18, 2009 at 9:16 am
Why I will keep these two..? what is the conceptual use of these users
Regards
Swayambhu
May 18, 2009 at 9:21 am
The sys user is a system user, used for system tables and databases. You are risking trashing your database if you remove these.
Information_schema is an ANSI standard. It doesn't hurt you to keep it, and it allows system view querying, which is more stable long term, than system views.
May 18, 2009 at 9:43 am
Thanks but
My client don't want to keep these orphaned users..
May 20, 2009 at 2:02 pm
sys and information_schemas are impartent, keep them and remove the guest. By default guest will have acess to all databases.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply