TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
louis Tunde
NA
278
61.7k
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.
Reply
Answers (
1
)
Random function on joins
Please help in Sql query with Group by for given scenario