1. Forum
  2. Usenet
  3. 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: [email protected]

    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: [email protected] <[email protected]> On Behalf Of Adrian Williamson Sent: 06 January 2022 16:43
    To: 'Rich Ford' <[email protected]>; [email protected] Subject: Re: [Info-ingres] Change Database Ownership

    I'd be typing something like:

    Sql [vnode]::jocks_database -ujock





    -----Original Message-----
    From: [email protected] <[email protected]> On Behalf Of Rich Ford
    Sent: 06 January 2022 16:34
    To: [email protected]
    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
    [email protected] https://lists.planetingres.org/mailman/listinfo/info-ingres

    _______________________________________________
    Info-ingres mailing list
    [email protected] 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: [email protected]

    I'd be typing something like:

    Sql [vnode]::jocks_database -ujock





    -----Original Message-----
    From: [email protected] <[email protected]> On Behalf Of Rich Ford
    Sent: 06 January 2022 16:34
    To: [email protected]
    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
    [email protected] https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)