Re: Logging in irrespective of the database access settings

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 09:43:17 -0400

> EXEC('GRANT EXEC ON ['+@o+'].['+@t+'] TO ['+@u+']')

Of course, you wouldn't GRANT EXEC on a table, you'd GRANT ALL.