Cannot CREATE VIEW that selects from a system table, despite having all grants
------------------------------------------------------------------------------
Key: CORE-5060
URL: http://tracker.firebirdsql.org/browse/CORE-5060
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC1
Reporter: Lukas Eder
Priority: Minor
I have created a user TEST, using which I can access the system tables:
SQL> SELECT 1 FROM rdb$database;
CONSTANT
============
1
I have granted ALL PRIVILEGES, including creating views to this user. For
instance:
SQL> create view v as select 1 a from t_book;
SQL> select * from v;
A
============
1
1
1
1
SQL> rollback;
SQL> drop view v;
But when I want to create a view that selects from the system table, something
goes wrong:
SQL> create view v as select 1 a from rdb$database;
Statement failed, SQLSTATE = 28000
unsuccessful metadata update
-CREATE VIEW V failed
-no permission for SELECT access to TABLE/VIEW RDB$DATABASE
>From a high level, I would say that this is a bug, right?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
