revoking permissions from table

Posted in 1999

Topics: Server Administration, Security, Permissions & Auditing

Austin Castro — Wed, 24 Feb 1999 19:47:07 -0600 — source: Informix-list mailing list archive (1991-1998)

Hi Guys, I have dba priveleges on a database. There's a table in this database that informix owns. I can grant permissions to the table with the 'as informix' clause but I cannot revoke. When I try the revoke statement using the 'as informix' clause I get a syntax error. Why can I grant but can't revoke. austin

↪ replying to Austin Castro

pauloamorim@uol.com.br — Thu, 25 Feb 1999 22:20:45 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7b3t15$hgl$1@news.xmission.com>, Austin Castro <acastro@wgs1.btl.net> wrote: > > Hi Guys, > > I have dba priveleges on a database. There's a table in this database > that informix owns. I can grant permissions to the table with the 'as > informix' clause but I cannot revoke. When I try the revoke statement > using the 'as informix' clause I get a syntax error. Why can I grant but > can't revoke. > > austin > > Hello You must have been granted by user informix (who owns the table), with grantor clause. That's why you can grant access to other users. However, you don't have permission to revoke access. This can be done only by the owner of the table, in this case, user informix. I agree with you, if I can grant, I should be able to revoke, but these are SQL rules.... Hope it helps.. Paulo Amorim TS&O Consulting Brasil -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own