Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.