Yes, I know it's an Oracle forum. For totally absurd situations, try this one.
I need read access to a SQL Server database so that I can copy data from it into my Oracle database. Unfortunately, the SQL Server database doesn't have a poper DBA so there is no-one who can grant read only access to the tables in database. The only option is that I supply the script to set up the access, even though I know nothing about SQL Server !
Can anyone tell me if SQL Server has a grant command in the same way as Oracle i.e. you can do