arsagperms and arsfolperms

[Mani]

Hi,

AG and folder permission tables (arsagperms and arsfolperms) have the permission columns as Integer (doc_perms for arsagperms and perms for arsfolperms). Is there a way to find, what these integer values correspond to?

Any idea is much appreciated. we are using CMOD 8.4.1.6 on DB2 9.5.5 and TSM 5.4 - Sun Solaris 5.10

the basic requirement is to check the permissions for each user/group for AG and folders.



Cheers
Mani

[Frederick Tybalt]

This was based on my research.

Convert the integer to binary and 1 denotes permissions are set and 0 other wise.

Permission attributes from top to bottom to be mapped to bits Right to Left

Code: [Select]

SQL : Select Id, Agid,  dec2bin(Doc_Perms)  From Arsagperms

Oracle Function :
CREATE OR REPLACE FUNCTION dec2bin (N in number) RETURN varchar2 IS
  binval varchar2(64);
  N2     number := N;
BEGIN
  while ( N2 > 0 ) loop
     binval := mod(N2, 2) || binval;
     N2 := trunc( N2 / 2 );
  end loop;
  return binval;
END dec2bin;