GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  Segment Security
Go To First  |  Previous Question  |  
 Segment Security  |  Question 14 of 14    Print  
I am trying to create a custom security profile in Oracle HRMS. So I went to the 'Security Profiles' screen -> Custom Security tab, check the 'custom restriction' check box and begin typing my SQL where clause. Here is my question:

I type this:
ASSIGNMENT.grade_id not in ( select grade_id from per_grades where PER_GRADES.NAME not like 'G%' or PER_GRADES.NAME not like 'M%') and it all works fine.

However, if I type per_all_assignments_f instead of ASSIGNMENT, I get ORA - 00904 error. Why does this happen? How will I know what alias to use in case I want to include a different table in the query?

  
Total Answers and Comments: 1 Last Update: July 24, 2008     Asked by: avidlearner 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 24, 2008 12:51:07   #1  
sabini Member Since: July 2008   Contribution: 1    

RE: I am trying to create a custom security profile in Oracle HRMS. So I went to the 'Security Profiles' screen -> Custom Security tab, check the 'custom restriction' check box and begin typing my SQL where clause. Here is my question:I type this:ASSIGNME
Please check your table alias name
 
Is this answer useful? Yes | No

 Related Questions

I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?
Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility. 

My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.
This functionality is available starting in Release 11i. In Releases 11 and lower, one cannot set security for standard reports. Security Rules will only limit users from a few functions (e.g. Account 

In Rel 11i with the intercompany segment being used, is it possible to have a security rule on the balancing segment (company) without it affecting the intercompany segment, since they share the same value set?
Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security. 

You cannot apply different security rules to the same responsibility for different users based on the user ID. You will have to create a new responsibility and define its own security rules. Then you can 

Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted. 

Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set 

Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?
There is not a way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would 

Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible? 
This is working as intended. Security rules will prohibit a responsibility from being able to enter in certain values as well as prohibit the viewing of those values as well. However security rules will 

Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?
Check your Accounting Flexfield Structure possibly it is frozen. Unfreeze the Structure and then you should be able to enable Security for the Segment.    

In General Ledger,a security rule of a parent with children, was setup to include the parent and assigned to a responsibility however, it is not functioning properly.
System allows the account the customer wanted but doesn't disallow the ones that are children of the parent values excluded. 


 Sponsored Links

 
Related Articles

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

Getting Started with Oracle and ODP.NET

ODP NET Developer’ s Guide by Jagadish Chatarji Pulakhandam Sunitha Paruchuri A practical guide for developers working with the Oracle Data Provider for NET and the Oracle Developer Tools for Visual Studio 2005 Application development with ODP NET Dealing with XML DB using ODP NET Oracle
 

PHP Oracle Web Development Review

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books The author is also an expert in open source technologies and SOA Service Oriented Architecture But besides
 

Step by Step Oracle PL-SQL Tutorial

This introductory tutorial to PL SQL will help you to understand the basic concepts of PL SQL Please review the following tutorials and practice the sample SQL Statements on your local Oracle Database Please note that you must learn these basic things before we actually start getting in to Advanced
 

Working with XML in Oracle

Working with XML in Oracle Introduction to XML Extensive markup language is the language which presents data in a human readable form of text The data can be anything from a purchase order or a stock quote or weather radar or a flight schedule it can be represented using XML XML is very similar to H
 

What is Consumer Profile

It is very important to document consumer profiles in the data warehouse. Consumer profile constitutes an essential component when the organization needs reports on the operating trends and patterns and how the organization is performing. If the organization is into a business competition, having
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape