Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to find out rows deleted from a table

ORA_AJDec 8 2009 — edited Oct 19 2010
Hi

Suppose i have a table with a sequence i.e its an header table containing GRN nos.Now suppose someone has deleted some of serials from it like i am having 1,2,4,5,6 etc 3 is missing.Now what will be the query to find out what are the serials that are missed out in the table.


--Ajay Sharma

Comments

Srinath Menon-Oracle 
Or do I have to create "Ent_DataArch_1_Role", "Ent_DataArch_2_Role"... in each of the databases they need access to?

It seems this is the only way to achieve this requirement.

AbbY-OC

Thanks Srinath,

Can OUD provide the solution to this then? We create a virtual group of databases and assign the user to that virtual group?

AbbY-OC

Hello OUD user community,
In the same thread - How is every one managing users & databases in their enterprise?
User_A needs access 5-Random databases
UserGroup_A needs access to a different set of databases
And so on...
Any suggestions would be a great help.
aBBy

Sandeep Kumar sk

@abby-oc Here is a reference/blog for implementing RBAC or Role-Based Access Control with CMU. There is a section on implementing RBAC with Active Directory. Hope this helps.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 16 2010
Added on Dec 8 2009
9 comments
18,900 views