ChrFrohn/AddServicePrincipalToSQL.ps1

Created May 17, 2024 11:35

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ChrFrohn/0764f98ecfc42b59c06d24ee048347df.js"></script>
Save ChrFrohn/0764f98ecfc42b59c06d24ee048347df to your computer and use it in GitHub Desktop.

Download ZIP

Raw

AddServicePrincipalToSQL.ps1

	CREATE USER [NameOfServicerincipal] FROM EXTERNAL PROVIDER;
	EXEC sp_addrolemember 'db_owner', 'NameOfServicePrincipal'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment