as400 sql authority problem 
Author Message
 as400 sql authority problem
I have created a collection on as400 V5.1 when i execute an update
statement it will be executed, but when I try to execute the same
command using another user I receive unathorised to that table.
  Noting that the ither user have been granted all object authority to
that collection.
  Is there any specific authority that user need it.


Sun, 31 Jul 2005 19:26:00 GMT
 as400 sql authority problem

On a 5250 session try to use this command:

GRTOBJAUT OBJ(COLLNAME) OBJTYPE(*LIB) USER(USERNAME) AUT(*ALL)

Bye

Franco



Tue, 02 Aug 2005 00:21:32 GMT
 as400 sql authority problem
... and then the command

GRTOBJAUT OBJ(COLLNAME/*ALL) OBJTYPE(*ALL) USER(USERNAME) AUT(*ALL)

Bye

Franco



Tue, 02 Aug 2005 00:23:23 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. GA-Atlanta-268447--AS400-SQL-CL-Programmer-AS400/SQL/CL

2. Problem with accessing a linked AS400 from MS SQL 2000

3. Problem!!! SQL Server - ODBC- AS400

4. Problems linking AS400 and SQL Server

5. Problems accessing AS400 as Linked Server in SQL-Server 7.0

6. Problems accessing AS400 as Linked Server in SQL-Server 7.0

7. 'NT AUTHORITY\ANONYMOUS LOGON' problem

8. Problem with NT AUTHORITY/NETWORK SERVICE

9. a problem in authority

10. problems and a question assigning SYSADM authority

11. DB2 authority problems

12. Oracle DB2/AS400 Access Manager and Oracle DB2/AS400 Transparent Gateway and UNIX connectivity


 
Powered by phpBB® Forum Software