473,385 Members | 1,370 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

how to carry out a conditional revoke

Did this:

revoke all on D_name_01.* from trial_user_01;

and got this response:

ERROR 1141 at line 4: There is no such grant
defined for user 'trial_user_01' on host '%'
Is is possible to issue a conditional revoke statement
so that the revoke is:

performed only if applicable
or
NOT performed if not applicable
Jul 20 '05 #1
0 1038

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Denis Martineau | last post by:
Some user accounts have been created some time ago and we have just found out that they were given privileges they should not have. However, I have no idea which account was used to create them and...
0
by: Ray | last post by:
I'm adding a table that needs to be more secured than the others, so I want to do a REVOKE ALL ON tablename.* from root but I get an error back There is no such grant defined for user 'root'...
1
by: jgctr4 | last post by:
I'm trying to print an HTML file using AxWebBrowser.ExecWB but it it gives a run time error "Trying to revoke a drop target that has not been registered". Does anyone have any suggestions? ...
2
by: teogra | last post by:
I have written an stored proc that reads from a text file and executes the script as dynamic sql. If the text file contains malicious code,I want to be able to detect it and prevent the stored...
0
by: Bryan Parkoff | last post by:
I break one U_WORD variable into two U_BYTE variables. I prefer to manipulate two U_BYTE variables instead of one U_WORD variable using Carry. Please look at my example using U_WORD variable...
1
by: John Wheeler | last post by:
Hi, I want to create the following stored procedure on a DB2 8.1 ESE no fixpack running on redhat linux 8.0 (Intel) CREATE PROCEDURE ADMIN.MYREVOKE ( ) MODIFIES SQL DATA BEGIN REVOKE...
8
by: cbielins | last post by:
I'm not sure if DB2 has a tool specifically for this, but I was wondering if there's a revoke tool that will completely wipe a group/user off the database without having to revoke from the table...
2
by: killbill | last post by:
Hi All, I am struggling with a problem but no fate till now. I have written a c# program which retrieve X509Certificates associated with Active Directory user. Now i want to revoke a selected...
2
by: Yves Gagnon | last post by:
Hi, I need to develop a WCF on a ms certificat autority that will revoke an existing certificate. My question: how to do that ? witch tool (c#) ? Do you have sample code that do that ? Thanks...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.