Bug #5503 Views: GRANT REFERENCES statement should be disallowed

Submitted: 10 Sep 2004 2:13 Modified: 9 Dec 2008 18:44
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.0.2-alpha OS:Linux (SuSE 8.2)
Assigned to: Paul DuBois CPU Architecture:Any

[10 Sep 2004 2:13] Peter Gulutzan 
Description:
MySQL 5.0 allows GRANT REFERENCES to apply to a view. It shouldn't. The 
REFERENCES privilege is applicable for constraints (foreign keys), and only base tables 
can be involved in that context. 

How to repeat:
mysql> create view v as select 'a'; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> grant references on v to pierre; 
Query OK, 0 rows affected (0.00 sec)
[19 Aug 2005 10:15] MySQL Verification Team 
verified with 5.0.12-beta-debug-log
[18 Jun 2008 10:52] Konstantin Osipov 
GRANT statement is performed on a name in a namespace. In particular, we don't check whether the underlying table is a view or a base table at the moment the grant is executed.
This needs to be documented in the manual.
[9 Dec 2008 18:44] Paul DuBois 
Per further discussion with PeterG, there is nothing to do here. Closing.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.