the REFERENCES privilege is only about creating a foreign key constraint? Practical use cases?
14
votes
3
answers
14519
views
Today I learned about
GRANT REFERENCES
. In years of SQL admin and dev work I never heard about it and never had issues with it.
quote from MySQL 5.7 Reference Manual / GRANT Syntax
> REFERENCES Enable foreign key creation. Levels: Global, database,
> table, column.
quote from PostgreSQL 9.6 / GRANT
> REFERENCES To create a foreign key constraint, it is necessary to have
> this privilege on both the referencing and referenced columns. The
> privilege may be granted for all columns of a table, or just specific
> columns.
is GRANT REFERENCES
only about creating a foreign key constraint? In what business case does it make sense to forbid creating a foreign key constraint (but allow to create tables)? Can you give me real world examples?
Asked by Sybil
(2578 rep)
Jan 3, 2017, 06:05 PM
Last activity: Mar 25, 2023, 01:44 AM
Last activity: Mar 25, 2023, 01:44 AM