sys.columns access issue

tags:

sql-server-2008

views:

answers:

sys.columns access issue

Hello everyone,

I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. I am wondering for SQL Server authentication mode (not Windows authentication mode), how to grant non-sa user to be able to access this view?

thanks in advance, George

+1 A:

Check the 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 the user. Open sql management studio with sa user, right click to a view you want to give permission, find permissions part and just add created non-sa sql user. There's also Security->Users Folder in your DB tree, where you can create user.

Good Luck!

hgulyan 2010-07-26 06:36:01

Hi hgulyan, thanks! The document is long, could you point me which command should I use please?

George2 2010-07-26 06:49:12

You want the user to select any view?

hgulyan 2010-07-26 06:51:58

Just sys.columns view, any good solutions?

George2 2010-07-26 06:54:03

@hgulyan, script in your reply seems dealing with SQL Agent? But my question has nothing to do with SQL Agent, just want to grant non-sa user to have permission to access view sys.columns. Any comments?

George2 2010-07-26 06:58:40

@George2, Check update

hgulyan 2010-07-26 06:59:16

Thanks, question answered!

George2 2010-07-26 13:26:29