sql server 2008 - sys.columns access issue -


i using sql server 2008 enterprise on windows server 2008 enterprise. wondering sql server authentication mode (not windows authentication mode), how grant non-sa user able access view?

thanks in advance, george

check link below

http://blog.gre-sqlserver-solutions.com/2010/02/sql-agent-giving-non-sa-users.html

and also

http://www.sypron.nl/grant_sa.html

update

create user. open sql management studio sa user, right click view want give permission, find permissions part , add created non-sa sql user. there's security->users folder in db tree, can create user.

good luck!


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -