Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

GRANT syntax in Firebird Language Reference incorrect [DOC125] #130

Closed
firebird-automations opened this issue May 20, 2016 · 2 comments
Closed

Comments

@firebird-automations
Copy link

Submitted by: @mrotteveel

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 `;`.

@mrotteveel
Copy link
Member

This is already fixed in fblangref30, but not yet in fblangref25

@mrotteveel
Copy link
Member

mrotteveel commented Apr 27, 2021

Fixed in fblangref25 as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants