New answers tagged role
0
The issue was with my replication script which was passing drop as @pre_creation_cmd in sp_addarticle.
So, when the table was dropped all the permissions was dropped as well.
Once I changed it to delete it fixed the issue.
Thanks
-1
here you can find what happens when you reinizialize a subscription:
https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators?view=sql-server-ver15#what-happens-to-permissions-granted-in-a-subscription-database-if-a-subscription-is-reinitialized
What happens to permissions ...
4
you can use GRANT ... WITH GRANT OPTION.
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-ver15
this option specifies that the security principal receiving the permission is given the ability to grant the specified permission to other security accounts.
1
A sketch for an alternative approach would be:
-- supertype for user / group, it is not clear from your post what
-- an appropriate name would be, so I'll just use `x`. each x is of a
-- certain type.
CREATE TABLE x_types
( x_type CHAR(1) NOT NULL PRIMARY KEY
, -- maybe add a description
);
INSERT INTO x_types (x_type) VALUES ('u'), ('g');
CREATE ...
Top 50 recent answers are included
