Change Database Ownership

10 views
Skip to first unread message

Rich Ford

unread,
Jan 6, 2022, 11:33:41 AMJan 6
to
I need to change ownership of some databases as the DBAs have left the company.

Part of the instructions state to "Login as the current dba of the database".

How is that accomplished?

Rich

Adrian Williamson

unread,
Jan 6, 2022, 11:44:09 AMJan 6
to Rich Ford, info-...@lists.planetingres.org
I'd be typing something like:

Sql [vnode]::jocks_database -ujock
_______________________________________________
Info-ingres mailing list
Info-...@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

Adrian Williamson

unread,
Jan 6, 2022, 11:54:18 AMJan 6
to Rich Ford, info-...@lists.planetingres.org

Sorry my closing square bracket was in the wrong place.

Sql [vnode::]jocks_database -ujock

The -u<username> lets you attach to the database as the identity given.

Your ID needs extended privs in accessdb to use it.

I can't remember which flag exactly, as I normally just set them all for
myself being the needy type that I am.



-----Original Message-----
From: info-ingr...@lists.planetingres.org
<info-ingr...@lists.planetingres.org> On Behalf Of Adrian Williamson
Sent: 06 January 2022 16:43
To: 'Rich Ford' <richf...@gmail.com>; info-...@lists.planetingres.org
Subject: Re: [Info-ingres] Change Database Ownership

I'd be typing something like:

Sql [vnode]::jocks_database -ujock





-----Original Message-----
From: info-ingr...@lists.planetingres.org
<info-ingr...@lists.planetingres.org> On Behalf Of Rich Ford
Sent: 06 January 2022 16:34
To: info-...@lists.planetingres.org
Subject: [Info-ingres] Change Database Ownership

Reply all
Reply to author
Forward
0 new messages