Primary Permission List Defaults

From TekiWiki

Jump to: navigation, search

This whole wiki has now moved to http://www.springboardsolutions.com/wiki

Go to this page Primary Permission List Defaults

Line 20: Line 20:
To find all the Primary Permission Lists missing, use the following SQL:
To find all the Primary Permission Lists missing, use the following SQL:
-
<code>select distinct OPRCLASS  
+
<pre>select distinct OPRCLASS  
from PSOPRDEFN o
from PSOPRDEFN o
where
where
Line 28: Line 28:
where  
where  
d.OPRCLASS=o.OPRCLASS
d.OPRCLASS=o.OPRCLASS
-
)</code>
+
)</pre>
To find operators missing a Primary Permission List:
To find operators missing a Primary Permission List:
Line 34: Line 34:
from PSOPRDEFN o
from PSOPRDEFN o
where
where
-
o.OPRCLASS is not null</pre>
+
o.OPRCLASS is null</pre>

Revision as of 23:09, 17 November 2010

Retrieved from "http://www.homemarketeer.com/wiki/index.php?title=Primary_Permission_List_Defaults"
Personal tools