Re: who is the owner..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dev (anonymous_at_discussions.microsoft.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 11:16:08 -0700

thanks Aaron,

so by doing this does the dbo user still stays the owner of my database. Also I want myUser to have full access to the database. Will it work fine.

thanks

Relevant Pages

  • Re: SP accessing other db
    ... And its dbo user was blank even db Properties shows BUILTIN\Administrator as ... Now the database name is hard-coded. ... > with System Admin permission. ... >> have the same owner so that the dbo users map to the same login. ...
    (microsoft.public.sqlserver.security)
  • Re: who is the owner..
    ... Also I want myUser to have full access to the database. ... Creating a table will not change the owner of a database. ... all relevant roles *except* denydatareader and denydatawriter. ...
    (microsoft.public.sqlserver.msde)
  • RE: Truncated INSERT statements when using sp_generate_inserts by Vyas
    ... SET NOCOUNT ON ... This procedure is also useful to create a database setup, ... ALSO NOTE THAT THIS PROCEDURE IS NOT UPDATED TO WORK WITH NEW DATA TYPES INTRODUCED IN SQL SERVER 2005 / YUKON ... IF @owner IS NULL ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... That means that the database's owner is MYDOMAIN\MyUserName ... My design machine is running Windows XP Pro. ... database diagram. ... Database diagram support objects cannot be installed because this ...
    (microsoft.public.sqlserver.security)
  • Re: conflicting object names in sql server 2000
    ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
    (microsoft.public.sqlserver.server)