Sample Header Ad - 728x90

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