Questions tagged [owner]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
138 views

What is the purpose of “Schema Owner”?

If I create a new schema and set the schema owner to another schema, for example dbo, what is the meaning of that in regards to my new schema? Does my new schema inherit the same permissions from it'...
2
votes
1answer
158 views

What is the best practice for the msdb database owner?

In the course of reading up on SQL Server security best practices, I learned that databases should generally be owned by a dedicated, low-privileged login (sometimes a separate one for each DB or each ...
0
votes
1answer
37 views

Why the owner of a database can't alter the tables of this database that are owned by other owners?

For now I don't understand why this access rights segregation exist. Is it implemented for some security reasons? Or can it be needed by some use cases I can't imagine right now? Knowing almost ...
5
votes
1answer
887 views

Select Permissions Across Multiple Schemas Within the Same Database

I have been asked by a client to implement some views for reporting purposes, the views will be accessed via PowerBI, Excel and SSRS. The designated user will only have access to the view and no ...
3
votes
1answer
202 views

How to maintain database ownership restoring across domains?

I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, ...