Re: "dbo" schema permissions question.

Hi Chris,

It would probably be better to have the user in SqlDependency.Start have a
different default schema than dbo (create schema foo authorization youruser;
alter user youruser with default_schema = foo). Otherwise you would have to
give it access to create objects in the dbo schema. Once you've done that,
the user needs CREATE SERVICE, CREATE QUEUE, and CREATE PROCEDURE. Because
SERVICE is at database scope (not schema scope) its queue or procedure
that's causing the error. Don't forget GRANT SUBSCRIBE QUERY NOTIFICATION to
the user executing the commands too.

Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb


"chris" <chris@xxxxxxxxxxx> wrote in message
news:1138483703.893069.160850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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: Database connection issue using SQL schema user account
    ... They can simplify permissions insofar as being able to have ... new objects created inside of a schema inherit permissions assigned to ... --The dbo user account is not the same thing as the dbo default ... The dbo user maps to db_owner/sysadmin. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Alter User for domain user
    ... connect to the server with Windows Authentication, the default schema ... (I used to have the dbo role, ... role on the server. ... schema different from dbo for a Windows login. ...
    (microsoft.public.sqlserver.security)
  • Re: sql server
    ... managment studio is connected to a sql server 2000 standard edition database. ... the default schema name for me on sql server 2005 management studio ... Assuming your database is using objects only in the dbo schema here is what ...
    (microsoft.public.sqlserver.setup)
  • Re: Stored Procedure Disappearing
    ... Did you use dbo. ... Qualifier to dbo or if you have used something else for the schema (owner) ... summary report which obtains data from a large stored procedure containing ...
    (microsoft.public.access.reports)
  • Re: creating tabes with full schema name
    ... Yeah, ADP has a lot of trouble with full schema name, especially when it's ... not dbo by default ). ... On forms, you can set the Record Source Qualifier and for control, you can ...
    (microsoft.public.access.adp.sqlserver)