F0101 Row Security

I am trying to implement row security on the F0101 so that particular users will only be able to say view AddressType1 of E (alias AT1). However the security is not having any effect. I have the Fom Value set to E and the Thru Value set to E, everything is N except view which is set to Y. I even tried it with everything set to N. When I logged out and back in I still have the ability to search any type in the address book.

Anyone out there implemented this Please advise.

Cleola Isaacs
CNC Administrator/Network Analyst
Xe Update 2 SP 16
Enterprise AS/400
WTS NT 4.0

Don't forget to set A through D and F thru Z as N

Make sure that in the data dictionary, for this data item row security has been been enabled.

Good Luck
Vivek Mohan
XE, Sp15.1, Oracle 8.1.6.3.0

Your workstation has cached the specs for the ATN1 data item. Each time you
turn on row security for a new data item you must refresh your global
tables. Make sure that you have row security turned on in the data dictinary
- turn row security for this data item 'ATN1'.

Next delete the global tables and data dictionary specs on all your test
Workstation. If you're running Citrix you'll have to rebuild the global
tables and data dictinary specs.

If you're tunning FAT clients then you're best of to create script to delete
these files periodically:

if exist dddict.ddb rename dddict.ddb *.d01
if exist dddict.xdb rename dddict.xdb *.x01
if exist ddtext.ddb rename ddtext.ddb *.d02
if exist ddtext.xdb rename ddtext.xdb *.x02
if exist glbltbl.ddb rename glbltbl.ddb *.d03
if exist glbltbl.xdb rename glbltbl.xdb *.x03


Colin

B733.2 SP17.1_F1
NT/Intel/Oracle 8.1.7.1

2-20-02

We use the process of *All lock down then grant back what the users =
need.
Attached is an excel file showing the MASTERALL security for the F0101.

Joy

[No message]

H hate replaying to myself....but I figured out that you cannot just secure out what you want the users to see you alos have to secure out the search type you don't want them to see. Needless to say this can become a little bit messy to keep a handle on, but it works if you really have to do it.

Cleola Isaacs
CNC Administrator/Network Analyst
Xe Update 2 SP 16
Enterprise AS/400
WTS NT 4.0

Hey Cleola,

As of SP16 you can actually use inclusive row security ie jbloggs can only
see E to E, the default before this was exclusive. The only problem being
you can only use one or the other globally. Check out doc ott-01-0099 on the
KG for a description of how it works.

Paul

XE SP17.1 Update 1
Win2K SP2 SQL2000
Citrix XP

(And truck loads of row security!!!)

Hey Cleola,

As of SP16 you can actually use inclusive row security ie jbloggs can only see E to E, the default before this was exclusive. The only problem being you can only use one or the other globally. Check out doc ott-01-0099 on the KG for a description of how it works.

Paul

XE SP17.1 Update 1
Win2K SP2 SQL2000
Citrix XP

(And truck loads of row security!!!)

Your attachments will go through this list, however I am interested in
receiving a copy of the document.

Please send a copy to [email protected]

Thanks,
James