SQLTeam.com | Weblogs | Forums

Doing a grant statement


#1

Suppose SAM now wants GEORGE to act as his security administrator. Write the SQL statement(s) needed to give GEORGE the necessary privileges.

this is my answer need help if this is correct

GRANT SELECT ON sysprocesses to [Domain\GEORGE] WITH GRANT OPTION
GRANT VIEW SERVER STATE TO[DOMAIN\GEORGE]
WITH GRANT OPTION
GO


#2

Sounds like a class/homework assignment.

What are "the necessary privileges"?
Btw, why are Sam and/or George looking at an ancient view like "sysprocesses"??


#3

yah I'm new in sql but I'm willing to learn and trying to figure it out
doesn't say what is nessesary privileges needed
but I suppose to get action like view, create, test,alter,delete in database


#4

yah I'm new in sql but I'm willing to learn and trying to figure it out doesn't say what is nessesary privileges needed but I suppose to get action like view, create, test,alter,delete in database


#5

This question is testing your knowledge of the built in server and/or db roles.
(It obviously is not very good at the moment.)