thanks,

learn something new everyday

In the Statement Privilege Revocation section of the document you display a image of User/Roles against DDL statements.

I have never come across this screen, could you tell me how to...

How did you query the database?

I find that QA outputs en-dashs etc okay.

Yes using the 'restore database' t-sql command. Not sure if EM allows you.

Just managed to setup a number of configs to oracle from SS2K

I found the following articles helped

For Windows 2000

http://support.microsoft.com/support/complus/mtsandoracle.asp?GSSNB=1

For NT

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280106

Does this normal user has permissions to read the access db

Create an admin account for yourself, and secure the SA account with a complex password so you can control access.

You can use this admin account to create your database.

When...

If you search this site you will find a number of other articles/threads on auditing/security

Also take a look at http://www.sqlsecurity.com

Regards

use the sp_changeobjectowner stored procedure to change the ownership.

Syntax

sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

From your error message I would say that your client is trying to use named pipes, not tcpip (the netlibrary in the error message is a nice easy way of...

Silly question I know, but I presume you have checked the netlibs ie your servers are using named pipes (ie DBNMPNTW as per your error message)

Regards

No luck, still get access denied.

I was doing it that way except I manually editing the tnsnames.ora and sqlnet.ora files, whereas you mentioned Net8 (I had hoped this was a...

I'll try that

thanks for your help

Firstly i'm creating a linked server using @provider = 'OraOLEDB.Oracle'.

Then when I try and use it I get the following error using QA to read a table 'OLE DB provider...

Its also possible that someone added a log file, when the 'administrator' was trying to find out why the filegroup was full. Since they rebooted the server lots of times...