Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Need create user only for view only on Symantec_CMDB

Created: 24 Dec 2013 | 2 comments

I need to create new user only allow her have view only on Symantec_CMDB, she need to run some kind query with her crystal report, all she ask is view only on Symantec_CMDB database.

How can I do this? I don't want give her full priviledge for this.

Thanks

 

Lillian

 

Operating Systems:

Comments 2 CommentsJump to latest comment

SK's picture

Public access to the database should suffice (public access to the Master db may also be needed, bit try without it first).

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

Anton_Nejolov's picture

Hi llian

Try this query: 

GRANT SELECT ON OBJECT:: ViewName1 TO UserName

Thanks,

Anton N.