.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Looks like I have to enable the guest user in one db...

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server
 

We are using app roles on 2005 and 2008 R2 for a large application. We just recently needed for the application to read some data from a second database on the same server. The only way that I can see to do this (other than ‘execute as’), is to enable the guest user in the second db. There will be no guest login. The data in the second db is all publicly available data, so I am not concerned about all logged in users having access to this data. We would only grant guest in that db select and execute rights on specific objects in that DB.

Is there anything that I ought to be worried about? Does enabling the guest account in one db marginalize the security of any other db on the server?




View Complete Post


More Related Resource Links

sitemap control user rights enable and disable

  

Hi,

iam using masterpage and sitemap in my project, what i want to is that

if user login is did, based on the user previlage in need to show the sitemap menu page

if user i have the previlage to see the page then i should enable that page otherwise

i need disable that page

looking for the valuable suggestions




Enable/Disable controls dynamically based on User settings

  
In my project I have a requirement that all controls in each window shall be enabled or visible dependent on user and the admin shall be able to change is a user will be able to use or see the control. I made a very simple test application that creates a user and gives him a list (will be loaded from db in real app) of the name of the controls in the window and also his settings. Then after initializing the window I use reflection to find the controls and set their isenabled/visibility properties. This solution does the thing but I'm wondering if there is a better solution. The main issue here is that each control must be set per user and thus roles wont work appropriate and also that I need to be able to change the settings at runtime.  

How to enable edit option for the user details in my settings

  
hi all,

I am new to SharePoint and SharePoint 2010.

I need to edit the user details when he is logged in, in my web Application, let me explain the scenario in detail.

1. User is log's in the application.

2. Clicks on "My Settings".

3. When the user views his details and clicks on the "Edit Item", then the user is not able to edit his profile but get only to "Attach File".

Checks performed by me:

1. Have checked is the user profile service is started for the current application or not (its started).

2. Have checked is the user profile synchronization service is started for the current application or not (its started).

Please help how can it be done as my site is not in the requirement.

thanks a lot for your help,

Arun Kumar :(

How to enable edit option for the user details in my settings

  

hi all,

I am new to SharePoint and SharePoint 2010.

I need to edit the user details when he is logged in, in my web Application, let me explain the scenario in detail.

1. User is log's in the application.

2. Clicks on "My Settings".

3. When the user views his details and clicks on the "Edit Item", then the user is not able to edit his profile but get only to "Attach File".

Checks performed by me:

1. Have checked is the user profile service is started for the current application or not (its started).

2. Have checked is the user profile synchronization service is started for the current application or not (its started).

Please help how can it be done as my site is not in the requirement.

thanks a lot for your help,

Arun Kumar :(


Enable User Instances in SQL Server

  

I'm just starting out and trying to connect to my first database using the following string:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

I get the following error during debug:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."

I've done this on every database - Master, Model, Tempdb, etc, and my database.

Still get the error.  I may not be enabling it correctly.  Any help would be appreciated.

The documentation suggests that I use user instances so that users without Admin rights can work with the database.  Add, delete, edit data.  Is this true?

 


How to enable a User to select n-Document from a custom WebPart

  

Hi,

i am developing a WebPart which have several Input Fields (Textboxes) and after he fills the Input Fields he need to select n-Documents from a specified Document Library.

But i dont know how to do that. How would you do that? Which ways are here possible?


Best regards,
Yavuz B.

My Sharepoint and Enterprise 2.0 Blog http://www.starcoder.net
Microsoft Sharepoint Resources & Blogs List

Enable/Disable controls dynamically based on User settings

  

I need an elegant way to enable/disable controls in my WPF application at run time using an external settings file(xml file)

I know this can be done using binding with Visibility/ IsEnabled property for all the controls, but how will i do change that in run time.

I also want to know whether combining the Settings.settings file and use bindings is the way to go.

There is documentation for VS2005 but not for VS2008 related to Settings.settings file approach.

I need recommendation for this type of features in WPF apps

Any help will be highly appreciated.

 

thanks

Sakti


how to enable filtering on user setting stored in profile as binary data in a gridview?

  

Hi!

I have a Profile with a Property like this:

<properties>

    <add name="UserDetails" type="oUserDetails" serializeAs="Binary"/>

</properties>

How can I show all Users with their Details in a GridWiew and how to enable filtering for values located in the UserDetails class. For example UserDetails.FavouriteColor which is a string.

Thanks,

Zsolt


MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

How Do I Enable Inline GridView Editing?

  
Now that you have created a site with Edit and Details views, how do you enable inline editing in a GridView control? This video shows you how, and also touches on routing.

Choosing Between a User Control or Web Part for SharePoint

  
SharePoint will only display Web Parts on a page. However, there are publicly available shims that allow you to write user controls and have them be displayed as a Web Part. From SharePoint's point of view, the shim is a Web Part. From the point of view of the user control, the shim is simply a control in .NET that is including the user control

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

  
Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

How to track the changes of user contacts(colleagues) by using SharePoint API

  
We might have seen colleague tracker web part which keep tracks the changes made in our contacts/colleagues details like profile/lists/sites. The same tracking mechanism can be implemented by using MOSS API in any custom web part/ web control/ feature/web service...

UserProfile.GetColleagueChanges is the method which returns all changes happened with the contacts, this method also accepts a Query (UserProfileChangeQuery) where we can specify different parameters to filter the changes

Configuring User Profiles in SharePoint Server 2010

  
Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

User Defined Functions in Microsoft SQL Server

  
User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common uses for functions. LEFT, the built in function for getting the left part of a string, and GETDATE, used for obtaining the current date and time, are two examples of function use. User Defined Functions enable the developer or DBA to create functions of their own, and save them inside SQL Server.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008

  

I am having problems with a user control. I want my solution to have a separate project for holding my user controls.


The main project can get a reference to this user control project and can import this user control dll into my main project. 


Thanks in advance,

Dheeraj Mittal

dhemittal@gmail.com


Multiple Instances of User Control

  

I have a user control that I place on a page severl times.  When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl.  So I get duplication of an insert that I do.  Is there a way to make sure these events are isolated so this doesn't happen.

Thanks,


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend