Pop-Up Thingie
Sidebar
Too Lazy BBS
Home
Forum
Files
Chat
Bulletins
Top doors
MOTD
BBS Stats
Radio
AvatarChat
Dark
Register
Log in
Username
Password
Sidebar
Forum
USENET
comp.databases.ingres
Change Database Ownership
From
Rich Ford
@richford990@gmail.com to
comp.databases.ingres
on Thu Jan 6 08:33:40 2022
From Newsgroup: comp.databases.ingres
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
--- Synchronet 3.21b-Linux NewsLink 1.2
From
Adrian Williamson
@adrian.williamson@rationalcommerce.com to
'Rich Ford'
on Thu Jan 6 16:43:24 2022
From Newsgroup: comp.databases.ingres
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
--- Synchronet 3.21b-Linux NewsLink 1.2
From
Adrian Williamson
@adrian.williamson@rationalcommerce.com to
'Rich Ford'
on Thu Jan 6 16:52:22 2022
From Newsgroup: comp.databases.ingres
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
--- Synchronet 3.21b-Linux NewsLink 1.2
Who's Online
Recent Visitors
Sauron
Mon Aug 17 05:50:20 2026
from
Purgatory
via
Telnet
Sauron
Sun Aug 16 22:51:04 2026
from
Purgatory
via
Telnet
Rixter
Sun Aug 16 22:39:57 2026
from
Madison, Nc
via
Telnet
Rixter
Sun Aug 16 10:20:30 2026
from
Madison, Nc
via
Telnet
System Info
Sysop:
Amessyroom
Location:
Fayetteville, NC
Users:
74
Nodes:
6 (
0
/
6
)
Uptime:
51:21:29
Calls:
1,101
Calls today:
1
Files:
1,339
Messages:
276,016