Hello,
Could You Help Me???? I would be very thankfull
I have used AdOX.catalog to view users of a database and their permissions on this database.
I have written the following code
private sub Form_Load()
dim conn as new ADODB.Connection
dim sec as new ADOX.Catalog
con.Open "Provider=MSDAORA.1;User ID=ers;Data Source=ers;Persist Security Info=False", "ers", "hugo"
set sec.ActiveConnection = conn
Dim Permission As RightsEnum
Permission = sec.Users(0).GetPermissions("Orders", adPermObjTable)
End Sub
Where 'Orders' is a table in the Oracle Database 'ers'
It doesn't matter whether the database is Oracle or Access because the error appeares in the two cases
The error which face me is as follows:
(Object or provider is not capable of performing requested operation.)
Your friend, Shihab