"cnsrun" rigths

Database
Fan

"cnsrun" rigths

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"

1 REPLY
Enthusiast

Re: "cnsrun" rigths

Hello friends, 

Does anybody have a solution to the same problem mentioned above?

I am at the same situation. Apart from logging in as DBC, is there any other way to solve this?

Regards,

SS