Forum Discussion
Datamart - SQL database capabilities
I am checking out the datamart preview feature. This is really exciting! But I have some questions.. Is it possible to provision a user(s) as member of the db_owner role? Can a user create store...
I have done the same as what have been written here - assigned a user the role viewer (that has the role public in the datbase) in my workspace and then tried to add the role public to the db_owner role. I wrote:
EXEC sp_addrolemember 'db_owner', 'public'
The answer I get is: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
Why does this happen? db_owner exist in my database and I am an admin_user.