default privs for public
Posted in 1996
According to the "Guide to SQL Reference, DEC 1991", when
creating a table, "all users who have been granted Connect
privilege to a database have all access privileges (except Alter,
Index and References) to the new table." Doesn't seem to be
true. I create a db, create a boatload of tables. Have NOT
granted public any rights (explicitly). Yet the following:
select * from systabauth;[snip a few rows]
informix public 23 s-------
msddba public 100 su-idx--
msddba public 101 su-idx--
msddba public 102 su-idx--
msddba public 103 su-idx--
[snip some more]
select * from sysusers;
username usertype priority password
msddba D 9
1 row(s) retrieved. We're using OnLine 5.0.5.
--
^^^^Cascades^^^^