Changing the Database Owner ?

P

PT

Does anyone know how to change the database owner? I am
converting a database and removing the security (other
measures will be used to secure the Database). I have
full access to the db but can't change the owner even
when logged in as the owner.
 
R

Rick Brandt

PT said:
Does anyone know how to change the database owner? I am
converting a database and removing the security (other
measures will be used to secure the Database). I have
full access to the db but can't change the owner even
when logged in as the owner.

Open Access as the new owner, create a new, blank database, and then import
all objects from the existing file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top