March 16, 2018 at 12:20 am
one 3rd party vendor database and all tables are defult schema is "dbo". I try to assign limited privileges after creating login and user.
Total 5 database.
created one login and mapped to all 5 database with default schema "dbo".
after that i try to assign SELECT, INSERT and UPDATE privileges, it won't work.
GRANT SELECT SCHEMA::[dbo] TO <username>.
cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself
Pls. suggest.
Thanks
March 16, 2018 at 9:08 am
SQL Galaxy - Friday, March 16, 2018 12:20 AMone 3rd party vendor database and all tables are defult schema is "dbo". I try to assign limited privileges after creating login and user.Total 5 database.
created one login and mapped to all 5 database with default schema "dbo".
after that i try to assign SELECT, INSERT and UPDATE privileges, it won't work.
GRANT SELECT SCHEMA::[dbo] TO <username>.cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself
Pls. suggest.
Thanks
correct syntax is
GRANT permission, permission........ ON SCHEMA :: schemaname TO theuser
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply