Altering table permissions when in use 1

[mikelawrence]

I'm using sql server 2005 and need to alter permissions on a particular table. The table is in use supporting a website so when i go into server management studio, right click on the table and try to change permissions in table properties i get a time out as the table is in use. What is the best way of getting around this, can i just isolate a particular table or do i have to take the whole system down? also if i take the system offline then i can't do anything with the tables so how would i go about it?

I'd appreciate any advice,

thanks

mike

 

[mrdenny]

Run the T/SQL Commands directly to grant the rights.

GRANT SELECT ON Table To UserName

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog