Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

A year spent in artificial intelligence is enough to make one believe in God.

devel / comp.databases.ingres / Re: [Info-ingres] Change Database Ownership

SubjectAuthor
* Change Database OwnershipRich Ford
+- Re: [Info-ingres] Change Database OwnershipAdrian Williamson
`- Re: [Info-ingres] Change Database OwnershipAdrian Williamson

1
Change Database Ownership

<639e93d1-9421-47ab-9fc5-9b419f37bdf2n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=188&group=comp.databases.ingres#188

  copy link   Newsgroups: comp.databases.ingres
X-Received: by 2002:a05:6214:268e:: with SMTP id gm14mr27698671qvb.24.1641486821419;
Thu, 06 Jan 2022 08:33:41 -0800 (PST)
X-Received: by 2002:a05:6830:4119:: with SMTP id w25mr41621564ott.98.1641486821132;
Thu, 06 Jan 2022 08:33:41 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Thu, 6 Jan 2022 08:33:40 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:ddc0:aaf8:a2aa:1b0c;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:ddc0:aaf8:a2aa:1b0c
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <639e93d1-9421-47ab-9fc5-9b419f37bdf2n@googlegroups.com>
Subject: Change Database Ownership
From: richford...@gmail.com (Rich Ford)
Injection-Date: Thu, 06 Jan 2022 16:33:41 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 6
 by: Rich Ford - Thu, 6 Jan 2022 16:33 UTC

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

Re: [Info-ingres] Change Database Ownership

<mailman.115.1641487407.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=189&group=comp.databases.ingres#189

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 06 Jan 2022 10:44:03 -0600
Return-Path: <adrian.williamson@rationalcommerce.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: adrian.w...@rationalcommerce.com (Adrian Williamson)
To: "'Rich Ford'" <richford990@gmail.com>, <info-ingres@lists.planetingres.org>
References: <639e93d1-9421-47ab-9fc5-9b419f37bdf2n@googlegroups.com>
In-Reply-To: <639e93d1-9421-47ab-9fc5-9b419f37bdf2n@googlegroups.com>
Date: Thu, 6 Jan 2022 16:43:24 -0000
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQF7SKvCwra8QQY5RpcHCRhOQeDiI60Pp2cQ
Content-Language: en-gb
X-Provags-ID: V03:K1:4ETNXmdaxWl+0BEjIV0WW6mNUQQNrkgzV6xsy0e0s0+G6ysy+Uv
erboGFCZFXoDKOwC3k9d7RFsEHyqsWodWK/12nZE10T4cS8NxyGyWCvriGgVwES0hAJaf1r
7VJqepprw/ltKDp2eCH8SrDnnnShHaee7tteba6kWVFLt4g2SiexI4CqPpN5wfKIPDTtsS2
hVeUqtEJNAIGUgVV2wouQ==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:RTeaFlkCkI8=:m4HrpS1ih+rn88JwM34XMa
8VY2VXDjg30QE9Ya1+mvhv8L6Xzd+1zboqeWD+VT+J5u7Im4y03KKDwaVDKYpztCRK2gMmA6B
95iLVwCaHgRlwLCpP/1Wnams6/xVhfICa6sVH0fb188qvZDpy1j6+iNZIKUSnclkSj4/Bu8G1
yxHJjTpDr7eQ5HHPPugVz0K4q73N5Eqfyvdem06vv0y+6lPIoIBAPqOVtkLgy67qJP+W4v1iT
Mgh7fOdVuPh3xevBy5S4pdk0uHceIKzRTZF9UX3AsFXAtVt593VgYih7Rw3f5v/eeRRewJwO3
ZyTOZnQhharqFzfXbYRf3L3oxTEHMimZ3M9QrbQd3oz6wfZleyUOz0XSciEHxhHRzSKSbx2/w
JpCrLsgt9fRo3cko4Fdu4NEIt/b7FIceWCsu8siDs/zZV/4XeUYQu2VvUvPCJZOI4G7OpHptD
bMR/i5z4ENiLqt/zesYHdmJ8NAgqmxA29DexGjGWpVRR7kMKYQCZWS2YyWYewC/93QkQ5pg1u
zLCjsHUfsJHYMMzisvABdecMpa5wyyPIu5MYF1LGH9nizkqx9QvdF88PetaPHc8SrVfNsexTl
WaPNhRvn/oHlm0opnRId5l3jyYZF8e1DD2KaJDeMu+prt3JII9sbdKmKN7TW5DOBLWhi93D5G
w1SZ0Nw9eToiAyinNzmXx9thEDJsWg1T08F+TovEoIbui0jdiNqDhFZTeUJlWFu+xhX6hNAKE
nllqUcM++XCeb0qJ1SDxXaZPfcXiTF5Q+YOxow==
Subject: Re: [Info-ingres] Change Database Ownership
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.115.1641487407.1681.info-ingres@lists.planetingres.org>
Lines: 29
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-Vmb0dZcf4f8ayC24KE89nsKySuT9g/Q7JpdxN+B8RE30+0nj3g+rzbQEKpBCfDvY1F8117b0SLCfPAz!V6fSWgdKBjeLDFQ1tiLwnA+0GjM2KuhbVwOyiI6wWZ7hUXvlF8te1nb1+8uwEV5pS/LfxxyROfTy!MLYJf08jf08ovNSgKO4DiRs=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4036
 by: Adrian Williamson - Thu, 6 Jan 2022 16:43 UTC

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

Re: [Info-ingres] Change Database Ownership

<mailman.116.1641487944.1681.info-ingres@lists.planetingres.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=190&group=comp.databases.ingres#190

  copy link   Newsgroups: comp.databases.ingres
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 06 Jan 2022 10:54:12 -0600
Return-Path: <adrian.williamson@rationalcommerce.com>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: adrian.w...@rationalcommerce.com (Adrian Williamson)
To: "'Rich Ford'" <richford990@gmail.com>, <info-ingres@lists.planetingres.org>
References: <639e93d1-9421-47ab-9fc5-9b419f37bdf2n@googlegroups.com>
<00df01d8031c$860790c0$9216b240$@rationalcommerce.com>
In-Reply-To: <00df01d8031c$860790c0$9216b240$@rationalcommerce.com>
Date: Thu, 6 Jan 2022 16:52:22 -0000
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQF7SKvCwra8QQY5RpcHCRhOQeDiIwEC0Rf3rQeTCxA=
Content-Language: en-gb
X-Provags-ID: V03:K1:ClofaY1gvzsHTkkRFsu+utzYaa81cg2LLMzuPpzYOhNqCKTkqIc
5PvMYkctpESjXS1L6/D2bTmi+7vojAPfR8OFuf3vNF6colSUzswxzY4oEiIcCwuGjXGw/nq
NUV64Rz52pSJOSFuUcihWsx2SH8AVDcM2oQeo1m9zxsiGKyItrnAvaMMT2ykG6A/tnzex/m
TwnwtcMKos3OCTED8MbMA==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:kWD9ATMEkUY=:mqPolf6lGwcD3q68TNZ24k
U0aEUHfZxEHrtpKpF9tZdcv63OwkSJ1QM1MgCS5zjd5+i4lIZmlWRZuhFkvrgYk5YtbeQT3UZ
4Gu0gSCwafJeoA6G0fCUqlxmGPC0AbkFxYaofy4IoVzKKkdzYXERX//1wUkqRoZmLRx9ib9zX
hOFrWDe4T5UW+zMGNcmYRCOQEz2KcOGC1wnu5UcU+ulW2Ku9OaOUmH7Wz8a5xCc+HRT+beycX
+Y7qp3MF2HSnXTSWNjoj/hOCYXPdPB7YD9P5dD9aiMNWXUwoROtvP5qnCW41Gi5PokJVVzkTt
myH5ctM6aEHGGnbuaYUYXOHv3ksGttVKwBn/cn0aR3a3ACtnZ9vcP7aKgPZ3I0iD8ZR9gKeZr
3W8xp9IQEv5K3+zx3pYa+jTTF8YPMD8ft2I1rrCuhPm4R+cow5STpglQ1YSBSW7DH1XW/wX7D
N8E6Ad2ebKQTbKtJNNxtqtPenQd6GEz2ho/Fbi7w9t1tcpEubXosjC+2nc4RfTkk4e8zWQ5y5
IDkOsmkRUJyo1CzL8z4iAUtVT/a3mZhCTs/PId5kNWpJMJXuf5XB9HXy5RRLuRsyq4muIAPQm
7J8dVgo5C9IKvqc5hMzhUsjZqvVQzmu6OtDPW1QH6zFOBk68Oix6kEgXiJxoJSt7QWYkkGXTW
VsJEWgC1VWRMOdBDuicu2GlYQz0MNmvgzuHEmVdv2GXdiGTuwSehzkPt0Vqf3rwYtpCa54a3a
DnfAKBz5QkAJRfwe/kzc2U7iZ7hDAMwnDkcC2Q==
Subject: Re: [Info-ingres] Change Database Ownership
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.116.1641487944.1681.info-ingres@lists.planetingres.org>
Lines: 55
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-uFJyfMMyjibxMxYmaeKdw9Xca0p9yQAAEzzLrRkdQlM24uSNqOTThMdNEeXxvDTFvf8A7xcxL1nyBz8!kEPnD0Elh164SjQUYceyevjnnNrTSrmBILSUNJUHL/bdNtINEiHeEvcd2Rmc6fEy6dts8flSOWEi!X4i4sa5EnD1W7et4c8o70XI=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4939
 by: Adrian Williamson - Thu, 6 Jan 2022 16:52 UTC

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

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor