Re: sysmaster database privileges
Saulius Raudys wrote:
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0011_01BDCCEF.8B7347C0
> Content-Type: text/plain;
> charset="WINDOWS-1257"
> Content-Transfer-Encoding: quoted-printable
>
> Hi
> sysdbspaces isn't in systables and systabauth and i can't SELECT =
> sysdbspaces. Error is -272: No SELECT permission. So, i can't do =
> archives and may be something else.
> My question is:
> how can i solve this problem?
>
> Saulius,
> Vilnius,
> Lithuania
>
Are you looking in the sysmaster database?
Based on your post, you are looking in databases called systables and
systabauth for a table called sysdbspaces. Unless your sysmaster
database is really messed up, the following should work:
SELECT * from sysmaster:sysdbspaces
John Carlson
Informix DBA
WH Smith, Inc.