"cnsrun" rigths
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


"cnsrun" rigths Expand / Collapse
Author
Message
Posted 9/24/2009 10:39:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/8/2009 7:58:41 AM
Posts: 2, Visits: 9
Hello,

I want to run ferret with a non-root user call "user1":



I have this result:

cnsrun: opened pipe to CNS localhost (fd=file5)
cnsrun: System status is 'Attempting to connect to CNS...'
cnsrun: System status is 'Connecting user sumoexpl...'
cnsrun: System status is 'Attempting to connect to CNS...completed.'
cnsrun: System status is 'CNS access denied: Illegal host'
cnsrun: System status is 'CNS access denied: Illegal host'
cnsrun: System status is 'CNS access denied: Illegal host'


What do I have to configure to allow my user "user1" to use "cnsrun"

In documentation, I have "http://www.teradataforum.com/teradata_pdf/b035-1102-061a_1.pdf", I've founded:

To CNS, this program appears to be an xdbw session. Therefore, to use this
command, the user running cnsrun must have access permission to run a DBW
session on the machine. To set up a user to have CNS access, use the Get
Permissions, Grant, and Revoke commands in the Database window. For more
information, see “DBW Supervisor Commands” in Teradata RDBMS Database
window.


With this other document, with the "root", I gave all rights to my user "user1"

root$ uname
server1

root$ cnsterm 6
Input Supervisor Command:
> grant user1@server1 all
CNSSUPV: permissions for user1@server1 updated
user1@server1: all


When I run cnsrun with ferret instruction, I have the same error messages...

How can I allow "user1" to run "cnsrun"

Post #16920
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 7:17pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.250. 6 queries. Compression Disabled.