View previous topic :: View next topic
|
Author |
Message |
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi All,
We have recently migrated our DB2 from V9 to V10. We have tables which have authorization as below
For example Y2002.CLM table has below authorization of table
Code: |
Grantor Grantee T Schema Name
* * * * *
-------- -------- - -------- -----
Y2002 Y2002 Y2002 CLM
DBAADMT4 PUBLIC* Y2002 CLM
|
We want to revoke access from PUBLIC at all location
Tried couple of options but nothing is working like
Code: |
REVOKE ALL ON TABLE Y2002.CLM FROM PUBLIC AT ALL LOCATIONS;
SQLERROR ON REVOKE COMMAND, PREPARE FUNCTION
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD AT. TOKEN <END-OF-STAT
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 2 0 0 -1 43 506 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000002' X'00000000' X'00000000' X'FFFFFFFF' X'000
INFORMATION
|
Please advise how we can rvoke this access except dropping and recreating table. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
REVOKE ALL ON Y2002.CLM FROM PUBLIC AT ALL LOCATIONS; |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Its not working guyc |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
How about the rest of your post explaining in which way it is not working? |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Nic Clouston wrote: |
How about the rest of your post explaining in which way it is not working? |
The board's not working, either |
|
Back to top |
|
|
|