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

grant select on to ;

Or is it set up totally differently ?
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width