Re: access cmd to sql server "grant insert on.."
From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 03/16/04
- Next message: Joe Fallon: "Re: Error while exporting filtered table as dbase5 file"
- Previous message: Douglas J. Steele: "Re: DSN less link to SQL"
- In reply to: Alison: "access cmd to sql server "grant insert on..""
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 23:03:22 -0500
You need to create a SPT query.
(SQL Pass Through.)
This uses the syntax of the SERVER (not Access).
So for Oracle commands you use Oracle syntax.
Ditto for SQL Server.
Connect to the server as a user that has rights to grant permissions to
other users. (sa or dbo).
Then write a new query and use the menu options:
Query
SQL Specific
Pass Through
In the Property window for your query enter a connection string as the power
user noted above.
The you can use normal Transact-SQL syntax:
grant select on table1 to someuser
Then run the query.
someuser should now be able to select records from table1.
To prove it, try to link to that table as someuser - it should now be in the
list of available tables.
(try linking before granting and you should not see it.)
-- Joe Fallon Access MVP "Alison" <anonymous@discussions.microsoft.com> wrote in message news:db1001c40aeb$778dcab0$a401280a@phx.gbl... > Hello > I'm trying to send a "grant insert on..." command to a > databse on sqlserver from access. I have the syntax ready > to go, can anyone help with how to send it to the sql > server database? > thanks much > alison >
- Next message: Joe Fallon: "Re: Error while exporting filtered table as dbase5 file"
- Previous message: Douglas J. Steele: "Re: DSN less link to SQL"
- In reply to: Alison: "access cmd to sql server "grant insert on..""
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
