Re: grant .. on table - 302
But guess what! Just because you have DBA authority does not man you can
revoke authority on those tables. Only the owner can do this?
What is up with this Informix? As a DBA I create the Database,
yet I can not revoke the authority that has been set. Even if I am the
owner or the Database as denoted by 9 in the priority column of sysusers.
Am I missing something here? This applies to the 5.XX and 7.XX online
engines.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet: cherylk@spamis.jcdc.doleta.gov
OR
cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On 26 Mar 1996, June Tong wrote:
> Robert G. Miller (73307.3247@compuserve.com) wrote:
> : Have created db and added tables with another user as their owner.
> : Cannot grant privileges to any users. Get 302 error. Am listed
> : on sysusers as D. Get 302 even if make root the owner.
> : Running online 7.11
>
> Try
> GRANT SELECT ON tabname TO user AS owner;>
>
> June
>
> ---- June Tong Informix Software ----
> ---- Senior Consultant (415) 926-6140 ----
> ---- International Support junet@informix.com ----
> ---- Location-du-jour: Beijing ----
>