Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Adding user to a defualt schema

Viewing 1 post (of 1 total)
  • Author
    Posts

  • 5habbaranks
    Member
    #165814

    Hi guys,

    Im having a bit of an issue with my SQL server what I am trying to do is map a user to the dbo default schema within MSSQL 2008. If I tick map and select the database then edit the default schema to dbo I get An exception occurred while executing a Transact-SQL statement or batch. User, Group or role ‘user’ already exists in the current database.

    Which is true the user does but I want to map it to that schema?

    Any ideas?

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: