|
If intentions are good to improve the security features,then we can help each other,mode of communication can be different.
|
|
|
|
|
How do we know your intentions are good?
|
|
|
|
|
This is the major drawback when we are talking to each other on a virtual environment that there is no button called "Trust Authentication".But i can only tell you that go through my profile on internet(Facebook:Search Harry kaizen Ivon) if you feel like,as i don't have any intentions check-o-meter to make someone believe that i am a good man with really good intentions to improve the holes in the systems.
Thanks for a great question.
|
|
|
|
|
The fact that you do not seem to understand the issues here speaks volumes about your suitability for the task you are asking about.
|
|
|
|
|
There is an obvious test to try - however I am not going to tell you because:
(1)Anyone with any serious experience of databases will know about this.
(2)If you are working on a security testing project and are having to ask this question then you should not be on that project.
(3)As others have said how can we trust your intentions?
[edit ] in your favour with regards to (1) I have come across a few 'experienced' DBA's who themselves have not heard about this 'feature'...
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
modified 3-Oct-11 4:31am.
|
|
|
|
|
GuyThiebaut wrote: this 'feature'...
Oh, you mean xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ? 
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
I think you do not believe in
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
I do!
You just need to ask your question another 1,000,000,000,000,000,000 times and people will give you the answer - that's what I do and it always works 
[edit] I think the reason why you have not had an answer so far is that the information you seek can be used to both protect and attack a system(that's why I won't give you the information)...
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Before asking u i had already asked 2*999,999,999,999,999,999 times 
Thanks for your support mate.
Some hints would certainly help.
|
|
|
|
|
HARISHCHOWDHARY wrote: Now please suggest me the ways to get into the database and to bypass the
authentication mechanisms so that i can suggest the improvements of the security
features of the application under test.
1. You can research that and buy books on the subject.
2. I would suggest that you tell your employer (presumably there is one) that you are not the best person to do this because real testing requires real and substantial knowledge. Without that such testing is unlikely to be close to sufficient.
|
|
|
|
|
Can you suggest me the name of the books as i have lot of them but in case if i missed an important one,, it will be a great help.
Thanks 
|
|
|
|
|
As others have pointed out, you aren't likely to get an answer here. There are two reasons:
1. Even if we believe that your intentions are good, this is a public forum which means that the answer is available for anybody to see; and we don't know their intentions.
2. Pen testing is a huge topic, best left to professionals. You can train in this side, and this might be your best option.
|
|
|
|
|
Hi,
I don't mean any disrespect... but if you have to ask these types of questions... maybe you should defer the security audit to a seasoned security professional. With that being said... some basics:
1.) Check for the Oracle default passwords.
2.) Implement an ascii permutative brute force password scanner. You could probably scan for weak passwords <= 5 characters in a single day.
3.) Use the Metasploit framework[^] to check for public vunerabilities[^].
4.) Purchase a Zero-Day licence at one of the security research groups. I would recommend Vupen[^].
Best Wishes,
-David Delaune
|
|
|
|
|
Hi,
Thanks for the help.Sometimes we have to ask this type of questions to find a new approach.But i am grateful for your answer.
With Warm Regards,
Harish Chaudhary
|
|
|
|
|
How to fetch records as
OTH
IA
LE
from table using Like query without using OR.as
select *from Issue where ReqControlNo like '%i%' or ReqControlNo like '%h%' or ReqControlNo like '%l%'
query should be as
select *from Issue where ReqControlNo like 'condition'
the condition should be in one string.
is there any solution please?
|
|
|
|
|
That's a task for the Union.
|
|
|
|
|
Is this SQL server? Recently I wrote a CLR Scalar Function that uses RegEx to do that, that might be the sort of thing you need. I doubt it's easily doable with straight SQL.
|
|
|
|
|
yes.
it is Sql Server.
Actually ,I want to search those records that have i ,l or h.
I want put the string in database.as %comm% for Records that have comm.
%crd% for records that have crd.
same way i want to store the string for i,l and h.in one string.
|
|
|
|
|
Uma Shankar Patel wrote: the condition should be in one string.
Could you explain that? To me, the conditional filter is the entire WHERE clause.
Are you by any chance looking for the full-text search[^]?
Bastard Programmer from Hell 
|
|
|
|
|
Try this
Declare @t table (Record Varchar(20))
Insert Into @t Select 'OTH' Union All Select 'IA' Union All Select 'LE' Union All Select 'xxx'
Select *
From @t
Where Record like '%[H,A,E]%'
/* Result */
Record
OTH
IA
LE
Hope this helps
Thanks in advance
Niladri Biswas
|
|
|
|
|
You already have best solution.
|
|
|
|
|
Finally I have achieve this by
select *from Issue where ReqControlNo like '[ilh]%'
|
|
|
|
|
i have to create a table item which has an attribute item category....category is a multivalued attribute...can anyone tell how to implement this?
create table item_info(itemno varchar(5),item_sno varchar(30),condition varchar(20),
color varchar(15),
corigin varchar(20),
Year_prod integer, PRIMARY KEY(itemno,item_sno))
|
|
|
|
|
you need to create a lookup table to store the category values and then a bridge table to store the categories for items.
CREATE TABLE Categories (
CategoryID int,
CategoryName varchar(100)
)
CREATE TABLE ItemCategories (
Itemno varchar(5),
CategoryID int
)
You can store multiple rows in the ItemCategories table for each item.
|
|
|
|
|
Create two tables as:
Item_Category
{ItemID int identity(1,1) primary key, Item_CategoryName NVARCHAR(100))
AND
another one is
Item
{
ItemSrNo int identity(1,1) primary key,
ItemID int, --foreign key references values from Item_Catory Table
Column3, ,,,n
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
