Give access to a table in a database in SQL-SERVER

Question

Give access to a table in a database in SQL-SERVER

Navigation

#1 by (0 votes)

-1

Does anyone know, how to give full permissions to a table in a database in SQL SEVER? Example: I have the user: tests_1 and I want him to only have full permissions to the table [GUIDES] of a database, so he can do (insert, delete, update, select).

If someone can help me please.

Thank you.

sql-server

asked by Gonzalo Rios 26.11.2018 в 15:50

source

1 answer

How to send a very large string to the php server with javascript asynchronously Insert a consecutive number in a field sorted by another field in sql 2012

score 0 · Accepted Answer

To give those permissions to a particular table, you have to use different GRANT s:

GRANT SELECT ON dbo.GUIAS TO pruebas_1;
GRANT INSERT ON dbo.GUIAS TO pruebas_1;
GRANT UPDATE ON dbo.GUIAS TO pruebas_1;
GRANT DELETE ON dbo.GUIAS TO pruebas_1;