"dbo" schema permissions question.

I have some ASP.NET 2.0 code executing
SqlDependency.Start(connectionstring) to a SQL 2005 database and I am
getting the following error:

System.Data.SqlClient.SqlException: The specified schema name "dbo"
either does not exist or you do not have permission to use it.

As a general SQL 2005 Security question, can anyone please inform me as
to how i would give my user permissions to the "dbo" schema? At
present the user has "dbo" set up as it's default schema, but I am not
sure what that does. Also my code works fine if I give the user
sysadmin rights.

Thanks,
Chris

.

Relevant Pages

  • Re: Default schema not working properly for AD groups
    ... CREATE LOGIN FROM WINDOWS; ... SQL Server MVP ... By deafult the objects are created with DBO schema. ...
    (microsoft.public.sqlserver.security)
  • Re: drop a database user. assign objects to dbo.
    ... you can avoid this problem by creating objects in a schema that ... same schema and references to the objects don't need to change. ... In SQL 2000, you can use the procedure sp_changeobjectowner, but it must be ... will be dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: script search for "dbo" in a database.
    ... dbo is not a role, it is a user and in SQL 2005, it is also a schema. ... Do you mean that you want to find members of the db_owner role? ... Kalen Delaney, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • SQL Adapter Disassembling Result Sets & Dynamic Parameters
    ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
    (microsoft.public.biztalk.general)
  • SQL Adapter Disassembling Result Sets & Dynamic Parameters
    ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
    (microsoft.public.biztalk.server)