database owner

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I find out who is the owner of the database.ie am I
the owner or is the user "admin"?
 
How do I find out who is the owner of the database.ie am I
the owner or is the user "admin"?
Click to expand...

The database should be the very first object listed in the "Change Owner"
tab of the Accounts/Permissions dialog.
 
-----Original Message-----


The database should be the very first object listed in the "Change Owner"
tab of the Accounts/Permissions dialog.


--
Click to expand...
OK I have found this dialog. But the option to change the
owner is greyed out. I only have 2 users in the database
myself and admin and the 2 default groups Admins and
Users. I am a member of both groups as is admin but I
still cannot change the database owner.Any Ideas?
 
OK I have found this dialog. But the option to change the
owner is greyed out. I only have 2 users in the database
myself and admin and the 2 default groups Admins and
Users. I am a member of both groups as is admin but I
still cannot change the database owner.Any Ideas?
Click to expand...

You can't change the database owner via that dialog. You need to create a
new database (while logged in as the user who is to be the owner). Then
import all objects from the database. Then set permissions on these
objects, as the import process will remove all security.
 
Back
Top