Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.INGRES
Re: [Info-ingres] Change Database Ownership
From
Adrian Williamson
@21:1/5 to
Rich Ford
on Thu Jan 6 16:52:22 2022
To:
info-ingres@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-ingres-bounces@lists.planetingres.org
<
info-ingres-bounces@lists.planetingres.org
> On Behalf Of Adrian Williamson Sent: 06 January 2022 16:43
To: 'Rich Ford' <
richford990@gmail.com
>;
info-ingres@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-ingres-bounces@lists.planetingres.org
<
info-ingres-bounces@lists.planetingres.org
> On Behalf Of Rich Ford
Sent: 06 January 2022 16:34
To:
info-ingres@lists.planetingres.org
Subject: [Info-ingres] Change Database Ownership
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
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
From
Adrian Williamson
@21:1/5 to
Rich Ford
on Thu Jan 6 16:43:24 2022
To:
info-ingres@lists.planetingres.org
I'd be typing something like:
Sql [vnode]::jocks_database -ujock
-----Original Message-----
From:
info-ingres-bounces@lists.planetingres.org
<
info-ingres-bounces@lists.planetingres.org
> On Behalf Of Rich Ford
Sent: 06 January 2022 16:34
To:
info-ingres@lists.planetingres.org
Subject: [Info-ingres] Change Database Ownership
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
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Daniel Garrod
Sat Feb 15 20:11:08 2025
from
Cambridge, Uk
via
Telnet
Bob Worm
Sat Feb 15 16:30:53 2025
from
Wales, Uk
via
Telnet
Voyteck
Sat Feb 15 16:28:13 2025
from
Poland
via
Telnet
Bob Worm
Sat Feb 15 14:25:51 2025
from
Wales, Uk
via
Telnet
Plume
Sat Feb 15 14:10:29 2025
from
Uk
via
Telnet
Daniel Garrod
Sat Feb 15 12:25:05 2025
from
Cambridge, Uk
via
Telnet
Razorclad
Sat Feb 15 06:23:43 2025
from
Denver, Co
via
Telnet
Flatearthdisciple
Sat Feb 15 04:25:14 2025
from
Moville, Ia
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
418
Nodes:
16 (
2
/
14
)
Uptime:
22:20:21
Calls:
8,765
Calls today:
8
Files:
13,287
D/L today:
3 files
(1,633K bytes)
Messages:
5,964,658