Schemas in SQL2005

• Santhosh Kumar-258781

  SSChasing Mays

  Points: 609

  More actions

  February 7, 2006 at 6:11 pm

  #168073

  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

• peterhe

  SSChampion

  Points: 11469

  More actions

  February 8, 2006 at 7:01 am

  #619512

  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