Hi Gangadhar,
CCS documentation is located here: https://support.symantec.com/en_US/article.DOC9205.html
You should look into the Planning and Deployment guide, there is info about "Privileges for Oracle":
To query targets on Oracle, CCS requires the following kinds of privileges:
■ Privileges for database-related queries
■ Privileges for platform-specific queries
■ Privileges on views to query database-related data sources
Though CCS requires only minimum privileges for data collection, in some cases
you may require to query targets using higher privileges. The Sudo functionality
permits you to execute a command on the target computer, as a super user, or
another user. For agent-less raw data collection on Oracle UNIX targets, you can
use the Oracle sudo (superuser do) functionality to run queries in the context of a
super user.
For information on minimum required privileges to query an Oracle database, see
http://www.symantec.com/docs/HOWTO83943