1) Grant permission for a user/role to create function in DB
GRANT CREATE FUNCTION TO [user/role]]
GO
2) Grant select and DRI(Declarative Referential Integrity) permission on a user define function in sql.
GRANT SELECT, REFERENCES ON [dbo].[func name] TO [user/role]
GO
Note:-DRI permission is required when function written type is data table
GRANT CREATE FUNCTION TO [user/role]]
GO
2) Grant select and DRI(Declarative Referential Integrity) permission on a user define function in sql.
GRANT SELECT, REFERENCES ON [dbo].[func name] TO [user/role]
GO
Note:-DRI permission is required when function written type is data table
No comments:
Post a Comment