Create db_owner with restrictions to other databases

Question

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

db_owner is referred to a single database, it's not a server role.

You just have to create the user as db_owner of the target database and leave it as "public" on the other databases.

-- Gianluca Sartori

PiMané SSChampion Points: 13965 More actions · Answer 2

but being public won't he have select and other permissions on the other databases?

I don't want the user to be able to perform cross database selects or other stuff like that.

Thanks,

Pedro

If you need to work better, try working less...

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Public role doesn't have table access, don't worry about that.

-- Gianluca Sartori

PiMané SSChampion Points: 13965 More actions · Answer 4

Many thanks...

Pedro

If you need to work better, try working less...

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

You could also avoid mapping the login to a db user completely, so that it can't access the database at all.

-- Gianluca Sartori