February 7, 2006 at 6:11 pm
Dear All,
I installed an SQL2005 and migrated our production DBs to SQL2005.. After migration, I can see following users and schemas by default... I could't able to drop either schema or user...So can you guys tell me what will be the impact if it exists in the production DB and if required, how can I drop them
(1) dbo (2) guest (3) information_schema (4) sys
I need only the SQL user that I created should exists under the security tab of the database...
Please help me
Regards
Santhosh
February 8, 2006 at 7:01 am
These are all sql server predefined schemas. I don't think you can drop them becuase they own objects, e.g. sys schema owns all system objects.
If you need to tight the security on your production server, you can achive this by granting/dennying permissions on certain DB objects/commands
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply