Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grant or With Grant

Status
Not open for further replies.
jamert

jamert

Programmer
Dec 9, 2007
80
CA
Hi applying permissions to a table for a user, when would one choose With Grant over Grant or vice versa, thanks
 
Sort by date Sort by votes
Use WITH GRANT OPTION if you want to give the user the ability to grant the specified permissions to other users.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
961
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
754
gmmastros
gmmastros
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
470
Chris Miller
Chris Miller
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
298
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top