How do I create a user in SQL-Server that only has access to one table, and can only insert rows

create the user, don't give any roles like db_datareader or db_datawriter

then GRANT INSERT ON YourTable TO SomeUser

if you want insert and select

GRANT INSERT, SELECT ON YourTable TO SomeUser

(1) To give a user with limited access to one Table only

GRANT SELECT ON [schemaName].[tableName] to [username]
Go

(2) To grant INSERT Permission.

GRANT INSERT ON [schemaName].[tableName] TO [username]

Related