Client Management Suite

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

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

Hi llian

Try this query: 

GRANT SELECT ON OBJECT:: ViewName1 TO UserName

Thanks,

Anton N.