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
Make it possible to change ownership of database objects [CORE5124] #5408
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @dyemanovTarget: 4.0 Initial [ 10621 ] => 4.0 Alpha 1 [ 10731 ] status: Open [ 1 ] => Open [ 1 ] |
Commented by: @aafemt Don't hurry with this ticket because ownership model wil be changed with introduction of schemas. |
Commented by: Bjoern Reimer (bnreimer) Then schemas should be part of V4 :-) I think it's worth thinking of SQL Syntax for changing the owner of an object (including database itself) like ALTER <Object> OWNER TO { new_owner | CURRENT_USER } and extend it when implementing schemas |
Commented by: @sim1984 Not in any way. The owner is not a schema. Do not repeat the mistakes Oracle. |
Commented by: @aafemt According to SQL standard database objects has no owner, they belong to schema. On its turn users can own schemas. |
Commented by: @AlexPeshkoff Certainly we should not follow Oracle's "user == schema". |
Commented by: Yiannis Bourkelis (yiannis) In MySQL / MariaDB it is very easy to assign user privileges to a database. Firebird could use the same method. Make a user the owner of the database: or assign privileges on a table of the database: |
Submitted by: @AlexPeshkoff
Votes: 5
Each object in the database is owned by the user which created it. That user as an owner of the object has full access to it. It will be great to be able to change object's ownership (kind of 'chown' command in *nixes).
The text was updated successfully, but these errors were encountered: