louis Tunde

louis Tunde

  • NA
  • 278
  • 62.1k

database security

Jul 15 2015 5:32 PM
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.

Answers (1)