Tag Info

Hot answers tagged

5

It could be as simple as: GRANT SELECT ON SCHEMA::[sitename] TO [user]; If there are procedures and functions you will also need: GRANT EXECUTE ON SCHEMA::[sitename] TO [user]; The full list of permissions applicable at the schema level is listed in the documentation: GRANT Schema Permissions (Transact-SQL) You can also set the default schema for ...


1

To perform what you are looking for based on this example: INSERT INTO synonym_bucket VALUES (23,37); SUGGESTION #1 DROP TABLE IF EXISTS synonym_bucket; CREATE TABLE synonym_bucket LIKE synonyms; ALTER TABLE synonym_bucket ENGINE=BLACKHOLE; DELIMITER $$ CREATE TRIGGER MakeTwoSynonyms AFTER INSERT ON synonym_bucket FOR EACH ROW BEGIN IF new.w1 ...



Only top voted, non community-wiki answers of a minimum length are eligible