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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

user access to system tables

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

Hi,

I've some developers who want to be able to select from some system tables. I'm reluctant to give this in case we get any locking issues. As an alternative I'm thinking of creating views with nolock hints, and granting them access to this. e.g.

CREATE VIEW vw_sysjobs
AS
select * FROM sysjobs WITH(NOLOCK)		

Is there a better way of doing this ? Am I right to asume that locking would be a potential problem on these tables ?

(SQL Server 2005)

thanks

 

 

 


Sean


View Complete Post


More Related Resource Links

Restricting access to System Databases for Windows User

  

Hi All,

     I was asked to provide access to windows user for only User databases in server. I added this user to db_reader role in all databases after creating login in Server. But here is the problem, this user can able to access System databases even I have n't assign any role for this login in system databases. Your response will be helpful  to fix this . Please let me know if I am missing here to understand it.

 

Thanks

Pradeep


Pradeep

IE closing when user try to access the document library

  
<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> IE closing (crashing) when user try to access the document library in share point site.  here we are using WSS2.0.  this problem for not accursed all the users , this problem happening on some users. 

InfoPath and Access - two parent tables and one child table

  

Hi there,

I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to the "Customer" table, which is again parent to the "Orders" table)

I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.

Cheers, Patrick


user control derived from System.Web.UI.WebControls.WebParts only fires its OnPreRender and CreateCh

  

 I have a application which uses webparts.

So my user controls are derived from System.Web.UI.WebControls.WebParts which makes them webparts.

I have everything setup and working fine as far as the personalization and webpart goes... every thing displays and works fine.

Except that 1 of my control needs to do a bit of work in the OnPreRender event and it turns out that event only gets fired when a user is loged in the application.

So lets imagine that an administrator while logged in switched to 'Sharedscope' within the webpartmanager and then has added the usercontrol/webpart 'calendar' to the top webpart zone. This then makes the 'calendar' control viewable by all and any user who visits the page wheter logged in or anonymous.

And this works fine and very well as it is supposed to. However in the 'Calendar' user control which is derived from System.Web.UI.WebControls.WebParts I have an overiden 'OnPreRender' event like this:

Protected Overrides Sub OnPreRender(ByVal e As EventArgs)

If Not Me.DesignMode Then

Me.isloaded = True

' Test for ScriptManager and register if it exists

sm = ScriptManager.GetCurrent(Page)

If sm Is Nothing Then _

Throw New HttpException("A ScriptManager control must exist on the current page.")

System.Data.SqlClient.SqlException: Login failed for user . Reason: The account is disable

  

Hi All,

Thank you for advance.

I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one year.

now sometimes i am getting the "System.Data.SqlClient.SqlException: Login failed for user '<UserName>'. Reason: The account is disabled." error.

then i restarted the windows service manually and working.

what is the problem in my sql server connection and how to fix that issue?


How can i restrict the user to login only from the system which he registered from the Computer.

  
Hi,I am Kartheek. ASP.Net Web developer. I got one requirement regarding security.In my website, if one user registered from a computer, we have to allow  that user to be able to access the site from that computer only. If he try to login from another system even in LAN, we have to deny the access.Please help me with this. Thanks in advance,Kartheek Challagundla.kartheekchk86@gmail.com

Data access from Remote system throwgh webservice

  
Hi, i wrote the webservice and configured in our server and having access the service through the browser from another system also working fine, But i am trying to access the service through in my application creating the proxy and accessing methods of the webservice, but it can't get the data from  the remote sqlserver through the webservice.    this is for my connection string  in  web config:   <add key="ConnectionString" value="server=EVEREST;initial catalog=MRMv1;uid=sa;pwd=kk"/>   the following the error was shown to me: Server was unable to process request. ---> Login failed for user 'sa' but i can login to sqlserver using 'sa' user in the remote server. how can i get the data from the remote server.        can you please guide to me. thanks and regards brite

merge replication system tables fragmentation issue

  
I have Merge replication going on in my environment. The problem is that system tables like MSmerge_content, MS merge _tombstone and MSmerge_genhistory are getting fragmented. We are rebuilding indexes time to time daily. But we want some good fix. Just send some good idea guys?

Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM'

  
Hi,   can someone help me with this error. Error: 18456, Severity: 14, State: 16 Login failed for user 'NT AUTHORITY\SYSTEM' [CLIENT:<local machine>] I've found several Threads but not with the NT AUTHORITY\SYSTEM.   Thanks for help.   Jens

Access denied when user clicks refresh BDC column button

  
Access denied occurs with any non Site Collection Administrator regardless of rights.  It only occurs in this site collections, others they are able to refresh.  In this particular collection they can add a BDC column to a list, edit an item and place/resolve a value in the bdc col; but when they refresh they are given an acess denied.  Any thoughts on what they need read access to?  This goes away if I give site admin privs (dont want to do that) or give them read only access on the web application (dont want to do that either).

Access a user created class in the form code

  
Hi Dear i have a litle problem i am developing a database application. In this app i write made two projects in the same solution. 1st named BussinessData and the 2nd one has a name Database Application. in business data i have add a libary class and made its region for easily code writing. now i want to get access at that class code from the application form code. example: sum of two numbers pubic class Sum #region "Public variables" dim a,b,c as integer #end region ' seperate region for getting values #region "Properites" public property a() as integer Get  return _a Set (by val value as sender)         _a=value end property #end region 'region for sum #region "Methods" public function sum() as integer c=a+b return c end function #end region in this way i have written the code and i want to get access this class from the form code. 'button_click code for the sum sum() plz help me to solve this problem  

Task assignment to user without read access in 2007 results in no email to assignee, no warning to a

  
It appears (from observation and searching) that SP 2007 will not send a task assignment email when the assignee does not have read access for the assigned task and there is no warning when assigning a task to someone who will be unable to read it. I have not been able to find any mentions of attempting to address this quirk by either an item event listener or a workflow that would either prevent the assignment or task the originating user to fix the issue by either changing the assignment or having them added to the appropriate group.  I could see one done badly causing a cascade of tasks. The approaches that I've thought about are: Attempt to block assignment by hooking ItemAdding and ItemUpdating on the task content type.  In ItemUpdating, you could use SPListItem.DoesUserHavePermissions since the SPListItem should be there, but you'd may have check the list since I don't think SPListItem is available at that time.  I could see this causing problems when the assignment is via workflow or something that doesn't like other code interfering with its task creation. Hooking ItemAdded and ItemUpdated to assign a new task to the assigning user to either change the assignment or have the assignee added to the users with access to the site. Define a workflow which could be enabled for a list that would check if any new or modified task is assigned to users with

Problem with access to a user in AD group

  
Hi all, We are managing our security in Sharepoint (WSS 3.0) with AD groups instead of Sharepoint groups. This worked fine until now. For an unknown reason, one single user from an AD group cannot access a page (while other users from the same group can). The group is also a distribution list in AD (so it's a security group and distribution list for emails). It includes several other distribution lists such as: L-All-Corporate-Employees    L-Administration          User 1          User 2           ...     L-Accounting         User 1         ... ...   So far I never had any issue with that kind of approach,  but yesterday we published a new web part page and wanted only the corporate employees to get access to it, so I broke rights inheritance on the page and added the L-All-Corporate-Employees group with View rights. As I already said, I tested with one user from the group (let's say from the L-Administration sub-group) and it works, now I receive an email from another user (let's say from the L-Accounting sub-group) which tells me he doesn't have access... But they're all part of the L-All-Corporate-Employees group, so they should all

Importing Access 2010 tables to SQL Server 2008 R2

  
I'm trying to import a series of Access 2010 tables to Sql Server 2008 R2.  The Access import drivers are for *.mdb (which if I recall was the file extension for Access when I was a kid, and don't recognize the .accdb file extention).  Similarly, the Excel driver is for Excel 2003.  Isn't there a driver and method to import directly to SQL 2008 from Access 2010? SQL is installed on my server, but Access is not installed on the server.  When I copy the file onto the server and try and open it directly into SQL, I get a 'no editor installed' error. I can't get the 'upsize' wizard to work becuase it won't open the connection to SQL, even though I enter the userid and password of the SQL DB owner.  I get the following error: ===================================================== Connection failed: ============================================================= I have to say I'm stumped.  The rest of the Office 2010 suite works really well together - perhaps I'm missing something very simple? Thanks!     I guess I could export my tables as Excel 2003 and then import them using Integration Services, or install SQL Express on my laptop and 'upsize' to that instance, but SQL State: ‘0100’ SQL Server Error: 11004 [Microsoft][ODBC SQL Server Dirver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQL

login failed for user nt authority/system

  
Please help on This error, I'm Using sql 2005 , windows authentication Event viewer,application: source :mssgl server,id 18456,servirty 14 state 16, logine failed for use "nt Athority/system,client: local machine , this error i'm gatting frequently Regards Asif

Creating a user limited to a few selected tables.

  
Hi there!   Im facing some troubles setting up a SQL user for my system. A need to create an SQL User, whom only have read access from the view A, read/write to table B and should not be able to see the remaining tables. I have spent some time on this trying to figure out how the permission system actually works, but I havent found the configuration that actually works. What I have done is created a user without any schemas and roles and under securables granted access to read in A and read/write in B. When I use this configuration I cannot access any tables. If I give the user db_datareader/db_datawriter I can perform all actions on all tables.   Can somebody guide me through how to create a user with these limitations? I'm really stuck.   Thanks in advance, Stig Jørgensen

how i can access a user created class in form code

  
Hi Dear i have a litle problem i am developing a database application. In this app i write made two projects in the same solution. 1st named BussinessData and the 2nd one has a name Database Application. in business data i have add a libary class and made its region for easily code writing. now i want to get access at that class code from the application form code. example: sum of two numbers pubic class Sum #region "Public variables" dim a,b,c as integer #end region ' seperate region for getting values #region "Properites" public property a() as integer Get  return _a Set (by val value as sender)         _a=value end property #end region 'region for sum #region "Methods" public function sum() as integer c=a+b return c end function #end region in this way i have written the code and i want to get access this class from the form code. 'button_click code for the sum sum() plz help me to solve this problem
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