How can we give a security on a database
using DMV and login,user other secuirty options please guide me.
View Complete Post
Hello all, I'm new to asp.net and I'm currently practising some few stuffs. I'm creating a hotel reservation system using ASP.net Web site in visual studio 2008 and I currently don't have an App_Data in my solution explorer unlike visual web developer.
1. I have planned to make users of the website login before making their reservations.
2. I have also planned to develop the website such that I will be able to know all reservations made by each user.
First and formost, I will like to know how I can access/View the security database?
Secondly, how do I link my custom made reservation database and the security database in order to achieve my second plan above.?
Someone help me.
As more organizations adopt XML-based Web Services, the need for message-level security has become evident. WS-Security, now supported in the Microsoft .NET Framework, addresses this need. Using the WS-Security framework, developers can implement channel sinks to intercept Remoting messages as they pass through the .NET Remoting infrastructure. The sink can read the message, change it, and pass it along. During this process, the message can be signed for added security. This article explains how to implement a Remoting channel sink that will modify the Remoting message by including a UserName token in the header, then sign the body using the token.
MSDN Magazine November 2003
I am using VS 2010 Professional with SQL Server 2008 Developer. I right click on the App_Data folder in solution explorer and add an existing item, then navigate to the correct database. However, I receive a pop up that Access is Denied. How do I fix this?
How do I limit what User/Groups can see a page in SharePoint 2007? Within on particular SITE, I want to be able to say, for example, only Users in the X group can see this page.
I see on the Page Setting the "Audience Targeting" option, but that does not restrict anyone outside that group from clicking "All Site Content" then finding and opening the page from under Pages.
Can someone point me in the right direction?
Thanks in advance.
I have role assignments on both the first and second level of my menus within my sitemap file. The first level works fine, and I only see items assigned to my role.
But roles assignments seem to have no effect on the second level. It seems like if you have access to the first level, you have access to everything on the second level.
Is this correct?
From my sitemap (either a SalesRep or an Administrator can see everything underneath):
<siteMapNode title="Administration" roles="SalesRep,Administrator" description="Admin" >
<siteMapNode title="CompanyMaintenance" roles="SalesRep" url="~/Admin/CompanyManagement.aspx" />
<siteMapNode title="Initialize Roles" roles="Administrator" url="~/Admin/Roles.aspx"/>
We have a moderately complex SSIS package that uses a script task to dynamically create a Transfer SQL Server Object task, which then moves data and schema of a varying definition
from source to destination. The SSIS package was written in BIDS 2005.
The source system is still SQL 2005 (with latest updates) and the destination system is now 2008r2 (with latest updates).
When the package run, we get the following error when we try to execute the dynamically created transfer task: Description: Execution failed with the following error: "Version90 database compatibility level is not supported.".
sp_dbcmptlevel for the source and destination databases returns "The current compatibility level is 90.".
Master on the target system is predictably at level 100.
This leads to several questions:
I am working on an asp.net application with membership controls and the SQL Server database. I have this put together, however it appears that adjustments need to be made to enhance security. Many websites have membership features, so I was wondering if there are some blog posts that describe the steps that need to be made to enhance security. Can someone make a few recommendations?
Has anyone successfully implemented item-level security in a SharePoint list using column values as the decision criteria? I realize this isn't out of the box functionality and would need to be custom coded.
For example, let's say that we have one document library that stores all of the HR documents about every employee in the company. One of the columns in the properties of the document stores which Office that employee reports to. There are HR staff that support each Office and should only have access to the files of employees who report to the same office that they do.
I know an option would be to create separate library or folder structures for each Office, but I'm curious if anyone has attempted to secure items or documents using properties instead.
after installing SP2 instance starts and stops with error:
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5831, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken
offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that
the script upgrade steps run to completion.
Already tried without success:
- enabled SA account (was disabled)
- uninstalled SP2 -> other error, but same problems with running the script