Security - Changing Ownership of DB

[Pharcyde]

Hey all!

I inherited 3 db's when i took my new job. People are now asking me to allocate them passwords, because they seem to have ll forgotten theirs!

My problem is this: I own everything within the db, apart from the db itself. I cannot allocate new users or passwords at all which renders me stuck!

This happens in 2/3 db's i use. The other one, for some reason allows me to set passwords. Any idea why? How do I get passed this before people start giving me real hassle! Maybe if I knew how to view peoples current passwords that could put them off for a while...


Cheers infinitely in advance, LeeBoy

 

[The_Doc_Man]

Under Tools >> Security on the menu bar, you will see two useful choices: User and Group Permissions as well as User and Group Accounts.

You cannot set a password for another person without logging in as that person, but you CAN (as administrator) clear the password. Go to the User and Group Accounts dialog box. Select the user from the drop-down list. There is a CLEAR PASSWORD button you can click. Then the person can log in and go to the same User and Group Accounts dialog to use the tab that allows one to Change Logon Password.

You take ownership of an object (including the database) on the Users and Groups Permissions dialog. Look for the drop-down that tells you what kind of objects you are looking at. One of the object types is "database" and that is where you would become the owner thereof. You cannot do this unless you have Administer permission on the database object.