I created a table in SQL server database as follows;
create table BOOKS
(
title char(10),
author char(15),
status char(3)
)
and I wanted to give the table a grant and revoke permission as follows;
grant select on BOOKS to panya
it displays the following error messages;
Msg 15151, level 16, state 1, line 1
cannot find the user 'panya', because it does not exist or you do not have permission.
Please what should I do. I am using SQL server 2008 R2.