|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server Remote Access ToolIs there a SQL Server remote access tool that can be placed on a desktop?
I'm looking for a tool that can access the SQL database without giving a user full server rights. Thanks. Hello:
The most user friendly would be using a front end in say Access- Give the user a security login and database user with the desired permissions in SQL Server. They can then go through a linked table in Access. Kyle McAdam, MCP -- Kyle McAdam ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2087811.html We are already using an Access front end. The DB owner may need to make
changes to the SQL db and I'd like to giv ehim access without giving him full admin rights to the server. Show quote "Kyle McAdam" wrote: > > Hello: > > The most user friendly would be using a front end in say Access- Give > the user a security login and database user with the desired > permissions in SQL Server. They can then go through a linked table in > Access. > > Kyle McAdam, MCP > > > > -- > Kyle McAdam > ------------------------------------------------------------------------ > Posted via http://www.mcse.ms > ------------------------------------------------------------------------ > View this thread: http://www.mcse.ms/message2087811.html > > SCT (SQL Server Comparison Tool) might be the tool which you are
looking for. It's main purpose is to compare databases, for example to detect if some data changed, or the structure of tables, stores procedures, etc. But it can be also used to view data and/or objects of one database - tables, procedures, functions, views, triggers, relationships. For example you can quickly see how many records are in the tables and do some basic reporting. >I'm looking for a tool that can access the SQL database You don't need to give a user any server rights. SCT is a safe,>without giving a user full server rights. 'read-only' program. Using it will never affect any data stored in your databases. SCT is a tool designed to perform analysis and comparisons; it is not designed to change any structure or data. You can download fully functional demo version of SCT from http://www.sql-server-tool.com/ HTH The user may need to modify the db at some point though. Will this tool
allow him to do that? Show quote "darek" wrote: > SCT (SQL Server Comparison Tool) might be the tool which you are > looking for. It's main purpose is to compare databases, for example to > detect if some data changed, or the structure of tables, stores > procedures, etc. But it can be also used to view data and/or objects > of one database - tables, procedures, functions, views, triggers, > relationships. For example you can quickly see how many records are in > the tables and do some basic reporting. > > >I'm looking for a tool that can access the SQL database > >without giving a user full server rights. > > You don't need to give a user any server rights. SCT is a safe, > 'read-only' program. Using it will never affect any data stored in your > databases. SCT is a tool designed to perform analysis and comparisons; > it is not designed to change any structure or data. > > You can download fully functional demo version of SCT from > > http://www.sql-server-tool.com/ > > > HTH > > No, current version of SQL Server Comparison Tool doesn't allow for any
modifications. Have you considered Enterprise Manager? It's part of the SQL Server
package..... -- Show quoteRegards, Hank Arnold "ekowalow" <ekowa***@discussions.microsoft.com> wrote in message news:C8EF8DF9-65D9-4457-B8B2-0C1F8CD4E49C@microsoft.com... > Is there a SQL Server remote access tool that can be placed on a desktop? > I'm looking for a tool that can access the SQL database without giving a > user > full server rights. > > Thanks. If the user is granted db owner priviledges, he/she can perform any
operation in the database they want. As far as a tool to use, if it can connect to the SQL Server database is can be used. The choice of tool is up to you. The operations that are allowed depend upon how you setup security within SQL Server. -- Show quoteMike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. "ekowalow" <ekowa***@discussions.microsoft.com> wrote in message news:C8EF8DF9-65D9-4457-B8B2-0C1F8CD4E49C@microsoft.com... > Is there a SQL Server remote access tool that can be placed on a desktop? > I'm looking for a tool that can access the SQL database without giving a > user > full server rights. > > Thanks.  |
|||||||||||||||||||||||
Other interesting topics