Good question, I'll get with our DB guy to get this info (we don't have direct access to do any SQL queries in the DB).
One theory we having is that one of the servers (server 1 that only has the 100000006 permission) was create with Multi Tenancy turned on (which is checked on by default) and that might have something to do with it. While Server 2, we unchecked it. We did eventually find this out and unchecked MultiTenancy on server 1 after the fact, but the CMDB Row Level fields never changed back. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, June 27, 2014 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: CMDB Row Level Security ** Lisa, what does it show when you look at the row in the DB, via SQL tools? I don't know how you would be seeing different results one one server vs the other. On Fri, Jun 27, 2014 at 8:14 AM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS <lisa.kemes....@dla.mil> wrote: ** 2 new 7.6.4SP5 Servers (in a server group, no load balancer). After everything is set up we start importing our CI’s and on server one 40% of the CI’s have 100000006 in the CMDBRowLevelSecurity field on the BMC_BaseElement form for server 1. Server 2 has 100000006 and Unrestricted Access on this same record same field (different server). Same Database. What could have caused this? Why is the same record’s row level permissions different on different servers sharing the same database???? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 <tel:%28717%29%20770-6437> Cell Phone: (717) 602-9460 <tel:%28717%29%20602-9460> lisa.ke...@devtechnology.com _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
