SQL Sever create a user with rights only to view a particular View or to execute only a particular stored procedure.

-
SQL Sever create a user with rights only to view a particular View or to execute only a particular stored procedure.
CREATE LOGIN user1 WITH PASSWORD = 'abc@123'
GO
CREATE USER user1
GO
CREATE ROLE AccessMonitoringViewRole;
GO
EXECUTE sp_addrolemember AccessMonitoringViewRole, user1
GO
--GRANT EXECUTE ON dbo.sproc1 TO execRole --this line is for granting execute on stored procedure
--below line is for granting view on a view
GRANT SELECT ON [dbo].[vAccessMonitoringView] TO AccessMonitoringViewRole
GO

Comments

Post a Comment

Popular posts from this blog

Authorize.net Integration eCommerce Payment Gateway ( Direct Post Method New! )

-
https://developer.authorize.net/integration/fifteenminutes/csharp These steps assume that your web server is on the public internet and can be accessed via a domain name or IP address. Step 1:Sign up for a Test Account. Sign up for a test account to obtain an API Login ID and Transaction Key. These keys will authenticate requests to the payment gateway. Step 2: Download the Authorize.Net C# SDK and include it in your project Download the SDK Create a new ASP.NET MVC application and add a reference to the AuthorizeNET.dll from the SDK Step 3: Modify web.config. Add the AuthorizeNET.Helpers namespace to the web.config, under system.web/pages: ... Step 4: Create a checkout form that posts directly to Authorize.Net Add the following code to the Home/Index View - this will create a form which will submit a test transaction to Authorize.Net (with hardcoded values). This code uses the SDKs CheckoutFormBuilder to create the form for you - just include your API login and Transa...
Read more

Visual Studio debuggin perfromance Improvement.

-
Solution Improving Visual studio debugging performance. 1. Disable Intellitrace completely 2. Tools -> Options -> IntelliTrace -> [ ] Enable IntelliTrace 3. Delete all the Visual studio breakpoints a. You may need to delete all your breakpoints---note that you need to click the "delete all breakpoints" button (or use Ctrl-Shft-F9), NOT just delete them one by one. If Visual Studio has mangled your solution settings the latter will not work. You may need to add a breakpoint first, in order for this to work (clever, eh?) i. If worst comes to worst, you may need to delete your .suo file and let Visual Studio start a new one from scratch. Note that you will lose your personal solution configuration settings, however (only for this solution, not any others). However, you may want to move/rename the file temporarily until you determine whether or not this is the problem; that way, you can always move it back. I have seen some online resources recommend del...
Read more

How to speed up your system

-
I found very nice artical about how to speed up your system at http://www.howtogeek.com/107280/the-best-tips-for-speeding-up-your-windows-pc/?utm_source=newsletter&utm_medium=email&utm_campaign=040312 The Best Tips for Speeding Up Your Windows PC If your computer has started to slow down, there are many options for speeding it up. Below, we show you some of the best tips for speeding up your PC, some from previous HTG articles and some described here. Turn off Startup Programs When you install a program in Windows, it may add a small program that runs when Windows starts. After installing a lot of software, your boot up process could become slow. If there are programs you don’t use much, they probably don’t need to start every time Windows does. You can disable startup programs manually or use the free tool CCleaner. You can also use Soluto to speed up boot time. Clean Up Unnecessary Files on Your Computer As you use your computer, files collect in all kinds of pla...
Read more