I need to change some databases ownership for DBAs who have left the company.
Part of the instructions state to "login as the CURRENT DBA of
On Jan 6, 2022, at 1:12 PM, Roy Hann <specially@processed.almost.meat> wrote:
Rich Ford wrote:
I need to change some databases ownership for DBAs who have left the company.
Part of the instructions state to "login as the CURRENT DBA of
...
Changing the name of the owner of the database now is probably
infeasible. The only supported way I can think of to do it would be to unload, destroy, recreate, and reload the database.
This is not ideal, but starting from where you are, I'd probably just
first make sure no one can ever log in using the current owners'
ID--delete their password or whatever it takes. Then to access the
databases from now on I would either use the -u flag to impersonate
the owner when I connect, or, once connected, use the SET SESSION AUTHORIZATION command to impersonate them.
Of course if you'd like some encouragement to get into unsupported
hackery, I or someone else here can probably whisper evil advice
if you insist. It's not my database. >:-)
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 21:57:31 |
Calls: | 8,764 |
Calls today: | 7 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,654 |