AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Connect to sql prompt remotely12/27/2022 With any additional permissions you want ( for example EXECUTE on certain SPs which select data). As I suggested if you can also map to relevant fixed database role (like db_datareader) and then provide them This should be done by means of relevant permissions (GRANT,DENY etc) set at the instance and db level and cant be restricted at the app level. Is there any method or app to use only SELECT statement.Īgain it has been repeatedly suggested by multiple people before, the answer is the same how many times you ask and how many thread you open! Unable to restrict INSERT,UPDATE and DELETE. To log in to the default instance of SQL Server. In that tools, we can able to execute all queries. Applies to: SQL Server (all supported versions) This topic describes how to test connectivity to an instance of SQL Server, use the sqlcmd utility. I dont think anyone would be able to help you further considering the confusing and contradictory requirements you're giving again and again. Now its up to you to take the ones you want and adapt it for your scenario. If you want to use SQL Server authentication then you need to specify the user name and password as follows: sqlcmd S tcp:SQL-A U sa. Only you knows what exactly your requirement is! For example if you want to connect using the TCP/IP protocol to a server named SQL-A using SQL Server’s default instance with Windows Authentication, the syntax will be as follows: sqlcmd S tcp:SQL-A. Henceforth we need access for only SELECT query for this user. SQL account should have datareader and datawriter access Otherwise we need some other Apps to do SELECT query only.Īgain you're asking two contradicting things! We need access for only SELECT query for this user. So we should not change it's password also. Also this SQL account credentials are using by more web services. Also that SQL account should have datareader and datawriter access. My Wiki User Page My MSDN Page My Personal Blog My Facebook PageĪctually the particular SQL user account is used on web.config file. Please Vote This As Helpful if it helps to solve your issue Please Mark This As Answer if it solved your issue This looks like a contradictory requirement to what you've specified aboveĭO you mean restricting few users from sqlserver acces? If yes, just don't give them access at all to your sqlserver instance We needs to access SQL Server using tools from client machines alone.Īll these are possible by installing SQL Management Studio itself on your client machine and then configuring the sqlserver instance on your server for remote access + opening relevant ports etcįOr this, you just need to map users to datareader role in databases you want for giving them only select access and execute permissions on relevant stored procedure which selects the data. We needs to restrict INSERT, UPDATE and DELETE queries from users. We needs to execute SELECT queries only from remote servers.
0 Comments
Read More
Leave a Reply. |