Re: Rights for Access2000 Upsizing-Wizard

From: Bernhard Lauber (BernhardLauber_at_discussions.microsoft.com)
Date: 03/09/05 

Date: Tue, 8 Mar 2005 23:43:04 -0800

Hello Sue

> Go into master and execute:
> grant create database to YourUser
Done. What I do in a scratch database is:
        use master
        CREATE DATABASE myDB
        go
        EXEC sp_addlogin 'usr', 'pwd'
        EXEC sp_grantdbaccess 'usr'
        EXEC sp_addrolemember 'db_owner', 'usr'
        grant CREATE DATABASE to usr
        go
        use myDB
        EXEC sp_grantdbaccess 'usr'
        exec sp_addrolemember 'db_owner', 'usr'
        go

> Then go into the database that will be used for upsizing and
> make the user the owner of the database by executing:
> sp_changedbowner 'YourUser'
When I execute this statement, I get the error that it is already owner of
db. Maybe because of sp_addrolemember 'db_owner'?

Relevant Pages

  • 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: statement not allowed within multi-statement transaction (Long)
    ... 100 Database does not exist in sysdatabases can not dettach ... --Verify database Exiists for detach ... >> I have a sample script that is available on request. ... >> I am getting the above error message when executing a stored procedure. ...
    (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)
  • Re: unknown database owner
    ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)