Database_scoped_credentials

SQL Server Administration
1

How can I insert a record in sys.database_scoped_credentials

I created a new database in Azure and I get the following error whey I try to create External data source:

The specified credential cannot be found or the user does not have permission to perform this action.

This is because sys.database_scoped_credentials table is empty

thanks
Mahmood

2

You won't be able to insert data directly into SQL Server system tables, and you don't want to, as it's likely to corrupt the state of the database.

1 Like
3

thank you