Viewing 2 posts - 1 through 2 (of 2 total)
The user has no owned schemas, and their only membership is the db_owner role.
OK, so in SSMS I'll remove their db_owner membership, and tick the db_datareader and db_datawriter roles.
(And I...
March 19, 2021 at 4:20 pm
#3860008
Thanks.
I want the user to be able to insert, amend and delete records within tables, but not to be allowed to create or delete any tables.
How do I achieve this?
March 18, 2021 at 5:16 pm
#3859590