Re: Table privileges
> I'm running on AIX 4.2.1 with Online 7.23.UC6
Hm. OK, can you send me and comp.databases.informix your platfiorm and
version information?
--
Ciao,
Billy
>
> No, PUBLIC only has CONNECT permission - I also checked this after I
> posted my e-mail.
> I tried this exercise on different tables - on some I (Informix) am the
> owner and on some not, with the same result on both. I still haven't
> found an answer to this.
It's possible that PUBLIC has DBA permission on the database. If that is
the
case, you need to revoke that permission first.
HTH.
--
Ciao,
Billy
+---------------------------------------------------------------------------
---+
| I used to be indecisive, but now I'm not so sure...
|
+---------------------------------------------------------------------------
---+
Dirk Moolman <dirkm@vodac.co.za> wrote in article
<01bd8263$d5918960$190210ac@8637hv863207.vodacnt>...
> Hi, I have not done this before. I am trying to revoke all rights from
> public on specific tables and then to grant select rights only, but for
> some reason the privileges stay active (are not revoked) on these tables
-
>
> "revoke all on <tabname> from public"
> "grant select on <tabname> to public"
>
> The commands are executed successfully, but when I do a table info in
> dbaccess afterwards, "public" still has full table rights - update,
insert,
> delete, etc.
>
> I also tried revoking these rights individually -
> "revoke update on <tabname> from public"
> but this crashes on -
> 580: Cannot revoke permission.
> 111: ISAM error: no record found.>
> How can I get around all this ?
>