Hi
DBO is just "special" user. My guess you are using SQL Server 2005 ,right?
In SQL Server 2005 user owner and schema are separeted. You will have to
read BOL on the subject. SCHEMA is juct a container for many objects for
security purposes
Hello, I've created a database role for the application user. They are
using
the dbo schema, so when I try to add dbo to the role, it won't let me.
Why
is this? And does this mean we would need to create some other schema
besides dbo?
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)
