Thursday, March 29, 2012

Database special users

What are the sys and information_schema special database users used for.

Hi!

sys and information_schema are special database users who has "public" access rights(by default) to access "INFORMATION_SCHEMA" and "SYS" system views, like: INFORMATION_SCHEMA.TABLES, INFORMATION_SCHEMA.COLUMNS, etc...

Note: And you cannot delete these users.

Thanks & Regards,

Kiran.Y

No comments:

Post a Comment