Issue Details (XML | Word | Printable)

Key: DOC-125
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Paul Vinkenoog
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Documentation

GRANT syntax in Firebird Language Reference incorrect

Created: 20/May/16 09:02 AM   Updated: 20/May/16 09:02 AM
Component/s: None
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
The syntax of GRANT (privileges) in the language reference is incorrect (http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-privs.html#fblangref25-security-privs-grant). It shows:

GRANT {
  <privileges> ON [TABLE] {tablename | viewname}
  | EXECUTE ON PROCEDURE procname
      }
TO <grantee_list>
  [WITH GRANT OPTION]} | [{GRANTED BY | AS} [USER] grantor];

This implies that WITH GRANT OPTION and GRANTED BY are mutually exclusive which is not the case. The correct syntax is:

GRANT {
  <privileges> ON [TABLE] {tablename | viewname}
  | EXECUTE ON PROCEDURE procname
      }
TO <grantee_list>
   [WITH GRANT OPTION]
   [{GRANTED BY | AS} [USER] grantor]

Note that I also removed an invalid `}` after [WITH GRANT OPTION] and the trailing `;`.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.