01-02-2013
Sorry, I ment
Is better to use local application function like read_data() which will check if user has entered data correctly or is better to transfer data check to database software ?
Data check on database can be very unproducitve and balance between performance and security is big issue. Local application can be issue of SQL injection.
So I wanna know from other more advanced users what they think.
6 More Discussions You Might Find Interesting
1. OS X (Apple)
I am looking at buying a new laptop in the next week or two. I want to know, would you reccommend the Ibook G4 800mhz or the powerbook G4 with 1 gig.
basically, I will not be video editing or anyhting llike that. I just want it for dekstop features, i.e. email, web browsing what not, I do a... (13 Replies)
Discussion started by: tuxwarrior
13 Replies
2. UNIX for Dummies Questions & Answers
I'm new to UNIX. We are using SunOS5.9. In order to maintain the control session active during large file tranfers in ftp, i like to send keep alive packets for every 10 seconds.I like to know the steps to be done to achieve this.
Please help me guys.Thanks in advance. (0 Replies)
Discussion started by: rpr
0 Replies
3. Shell Programming and Scripting
Hi Shell Scripting Experts,
I have a shell script running daily on a remote machine through ssh. To avoid the trouble of restarting the script when ssh disconnects, I use screen (a unix tool) and run the script within a screen session.
What this script does is to ask the user to input y or n... (2 Replies)
Discussion started by: jeff_cen
2 Replies
4. Shell Programming and Scripting
All,
I am trying to figure out a script to run in windows that will allow me to match on First column in file1 to 8th Column in File2 then
Insert file1 column2 to file2 column4 then create a new file.
File1:
12345 Sam
12346 Bob
12347 Bill
File2:... (1 Reply)
Discussion started by: darkoth
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am trying to send email with attacment and body using "mailx"
(cat body.txt; uuencode attach.txt) | mailx -s "Attachment" abc@xyz.com
When i type this command, the shell is still waiting for me to enter something in standard input and press control D before it sends a mail and... (2 Replies)
Discussion started by: aliaszero
2 Replies
6. AIX
/tmp/man18809436: Invalid file system control data detected
Help me
what do I do?
Если знаете русскии, пишите на нем. (2 Replies)
Discussion started by: islily
2 Replies
LEARN ABOUT REDHAT
drop_user
DROP
USER(7) SQL Commands DROP USER(7)
NAME
DROP USER - remove a database user account
SYNOPSIS
DROP USER name
DESCRIPTION
DROP USER removes the specified user from the database. It does not remove tables, views, or other objects owned by the user. If the user
owns any database, an error is raised.
PARAMETERS
name The name of an existing user.
DIAGNOSTICS
DROP USER
The message returned if the user is successfully deleted.
ERROR: DROP USER: user "name" does not exist
This message occurs if the user name is not found.
DROP USER: user "name" owns database "name", cannot be removed
You must drop the database first or change its ownership.
NOTES
Use CREATE USER [create_user(7)] to add new users, and ALTER USER [alter_user(7)] to change a user's attributes. PostgreSQL includes a
program dropuser [dropuser(1)] that has the same functionality as this command (in fact, it calls this command) but can be run from the
command shell.
EXAMPLES
To drop a user account:
DROP USER jonathan;
COMPATIBILITY
The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
SEE ALSO
CREATE USER [create_user(7)], ALTER USER [alter_user(l)], dropuser(1)
SQL - Language Statements 2002-11-22 DROP USER(7)