database security

Question

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.

Answer 1

Hello Priya,

 

  Please go through this link

http://stackoverflow.com/questions/16998873/random-join-in-sql-server