Showing posts with label hiding the column from User. Show all posts
Showing posts with label hiding the column from User. Show all posts

Monday, March 18, 2013

OBI 11g Column Permission Setting: PROJECT_INACCESSIBLE_COLUMN_AS_NULL


In Oracle BI 10g, If a column is hidden from a user and when the User logs in there would be an error.

To fix this error, we have to change the parameter  PROJECT_INACCESSIBLE_COLUMN_AS_NULL in NQSConfig.ini

In Oracle BI 11g,  the parameter value is set to ‘YES’ :


[SECURITY]

DEFAULT_PRIVILEGES = READ;  
PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;  # default is no

# Note that the paths below should be relative to the instance
# config directories if specified.  e.g.,
# $(ORACLE_INSTANCE)/config/OracleBIServerComponent/<instance_name>
#IGNORE_LDAP_PWD_EXPIRY_WARNING = NO;     // default is no.