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

Jump to bottom

Grant execute on UDF [CORE2554] #2964

Closed
firebird-automations opened this issue Jul 14, 2009 · 10 comments
Closed

Grant execute on UDF [CORE2554] #2964

firebird-automations opened this issue Jul 14, 2009 · 10 comments
Assignees
@dyemanov
Labels
component: engine fix-version: 3.0 Alpha 1 priority: major qa: deferred type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Pavel Radchenko (pvr)

Is related to QA645

Attachments:
c2554.sql

GRANT EXECUTE ON FUNCTION {udf_name} TO {user| role} [WITH GRANT OPTION]

====== Test Details ======

Sent letter to dimitr et al, 23.02.18 14:54. Waiting for reply.
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

Component: Engine [ 10000 ]

Component: UDF [ 10002 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

description: GRANT EXECUTE ON EXTERNAL FUNCTION {udf_name} TO {user| role} [WITH GRANT OPTION] => GRANT EXECUTE ON FUNCTION {udf_name} TO {user| role} [WITH GRANT OPTION]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Implemented for both legacy UDFs and new PSQL and external functions.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA645 [ QA645 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Non SYSDBA user who has right to execute UDF and/or PSQL function and got this right with grant option can NOT give such right to another user.
This relates only to FUNCTIONS, i.e. stored procedures, tables etc - are not affected.

See attached file for illustration.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: c2554.sql [ 13009 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Deferred

Test Details: Sent letter to dimitr et al, 23.02.18 14:54. Waiting for reply.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dyemanov dyemanov

Labels
component: engine fix-version: 3.0 Alpha 1 priority: major qa: deferred type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dyemanov @firebird-automations