AZR-SQL101 Create Credential
--
-- Database Credential
--
-- Drop db credential
IF EXISTS(SELECT * FROM sys.database_credentials WHERE name = '<<CrendentialName>>')
DROP DATABASE SCOPED CREDENTIAL <<CrendentialName>> ;
GO
-- Create db credential
CREATE DATABASE SCOPED CREDENTIAL <<CrendentialName>>
WITH IDENTITY = '<<UserName>>',
SECRET = '<<UserStrongPassword>>';
GO
-- Database Credential
--
-- Drop db credential
IF EXISTS(SELECT * FROM sys.database_credentials WHERE name = '<<CrendentialName>>')
DROP DATABASE SCOPED CREDENTIAL <<CrendentialName>> ;
GO
-- Create db credential
CREATE DATABASE SCOPED CREDENTIAL <<CrendentialName>>
WITH IDENTITY = '<<UserName>>',
SECRET = '<<UserStrongPassword>>';
GO
Till Next Time
Reacties
Een reactie posten