Loading

How to grant access to table in db?

Akshaya arumugam

8y812

I have a db which contains a table .I would like grant insert,update access to user with another login to the same table which is under some other user login db.How to do it?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayakumar Balasubramaniam8y ago
Hi Akshaya,

The below documentaion from Microsoft will help you, if not let me know i can give you samples.

https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?view=sql-server-2017

Please mark this answer as accepted, if it helps you.