Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can drop command be disabled?

Status
Not open for further replies.
mars19301

mars19301

MIS
May 31, 2001
69
US
Our application provides for some of our users to write their own sql off a menu option. Is there a way to disable the drop command for these users? Thanks for any insight.

Jim
 
Sort by date Sort by votes
Hi,

Set user level previleges on the particular tables.

Ramesh
 
Upvote 0 Downvote
Revoke DBA priviledges from any user you don't want to have that ability on a database or table level.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
285
tuccero
tuccero
daYorkie
  • Locked
  • Question
How many UNIONs can i use in a single query?
Replies
2
Views
193
daYorkie
daYorkie
welcome07
  • Locked
  • Question
What should Be Sequence of Installing IDS in DEV Server.
Replies
0
Views
162
welcome07
welcome07
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
200
jamescpp
jamescpp
aft5425
  • Locked
  • Question
help using dbload command utility; substitute values when i found spaces
Replies
0
Views
128
aft5425
aft5425

Part and Inventory Search

Sponsor

Back
Top