asp_databases thread: How can I grant the permission of select and update to a column
Message #1 by "jino" <jino1380@y...> on Tue, 20 Aug 2002 05:37:27
|
|
hi
I use sql server 2000,when I mark the select and update boxes for a
column,it's changes doesn't save and I must do it again and again,I get
confused,help me
Message #2 by Vijay G <happygv@y...> on Tue, 20 Aug 2002 20:47:25 -0700 (PDT)
|
|
Use Grant statement in Query analyser to grant the relevant permission u need to.
See BOL about GRANT for more help
GRANT <PERMISSION,PERMISSION,.....> on <OBJECT> to <USER_OBJECT>
eg : grant select, update on testtable to testuser
Cheers!!!
Vijay G
jino wrote:hi
I use sql server 2000,when I mark the select and update boxes for a
column,it's changes doesn't save and I must do it again and again,I get
confused,help me
---------------------------------
Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs
|
View Cart
