I have a simple .NET 3.5 app for changing some database fields using an ODBCDataSet. Now the Feature Creep is asking if I can hide or show tabs and other controls based on the user's database permissions. Ideally, I would like to control the permissions only on the SQL Server using Windows user groups, and the app would not have any built-in authentication or permission system--it simply uses the logged-in user's Windows account for the database connection. So thus it would have to "test" the permissions to determine whether or not to show the tabs for the user. For example, if they have "write" permissions to a certain table, then the tab for editing it would be visible; if not, the tab never loads for them. How can I list or test the user's permissions to the ODBCDataSet?
I am writing an Excel addin to read/insert/update/delete SQL data. I am looking for tips or code samples to check if the user running the addin has select/insert/update/delete permissions. this would work on SQL 2000, 2005 and 2008. I have found the following which works for SQL 2005 (and likely 2008, though I have not tested).
Use AdventureWorks Go SELECT * FROM fn_my_permissions('Sales.vIndividualCustomer', 'OBJECT'); Go
I've developed a Windows Form application that contains a function where a user will query AD using a users last name in an attempt to get a list of all domain users that contain all or part of the last name. This function works well if the user is an administrator, however in some cases a department manager, who only exist in the Domain User AD group, needs to use this function. When the user with only Domain User rights uses the function all queries come back empty. I can take the same application to another domain and user with just Domain User rights can use the function just fine.
I assume that the first domain that I mentioned might be using Group Policy to prevent Domain Users from making a query against AD.
Is it truly a Group Policy or some other setting within the domain that prevents this?
The current administrator of the first domain I spoke of is fairly new and has no idea of the workings of AD or Group Policy. All domains that I mentioned here I believe are running Windows 2003 Domains.
I am working in VB.Net 2010 framework 2.0. In my application I want to run a Setup.exe with Process.start. I want to know that whether the user who has started the my application is having the rights to run the setup.exe
I am creating a multi-user application using VB 2005 Pro and SQL Server 2005.I would like to know what your ideas are when it comes to managing user permissions in regard to being able to view, add, edit and delete information in the database? Do you think I should have the end user type in the information into the VB application which then will create an SQL server user and then apply permissions to that security user or should I fine-grain the application by allowing groups to be created and then assigning permissions and users to those groups?
I have some code that queries all the printers on our print server and returns a list. I need this code to work so please don't reply with comments asking why I am using it when you can simply type \Server to list the printers (I know this, but need the code to work as part of a larger application). When running the following code on an IT PC with admin rights, it works. When running on a restricted user PC, it doesn't. How can I add permissions in code to elevate the EXE to 'run as administrator'? [Code]
I'm writing and application that creates a home folder for a given user. I can set the permissions fine, but on some of the folders I need to remove a specific group/user, "Everyone" would be an example for one of the folders. I can make it so that they are denied from all the permissions on the folder, but I can't actually get the group/user remove.
I'm creating an application that works with another I have no control over. My application needs to be able to create a user and change share permissions. Currently I am able to make a share, but I can't figure out how to set access permissions for that share.
The idea is that the newly created user (w/ password) will have permissions on the share I create.
I use the following code in order to check if certin user exists in the DACL:
Dim l_managemantObject As ManagementBaseObject() = CType(securityDescriptor.Properties("DACL").Value, ManagementBaseObject()) For Each mObject As ManagementBaseObject In l_managemantObject l_name = CType(mObject.GetPropertyValue("Trustee"), ManagementBaseObject).Properties("Name").Value.ToString If CType(mObject.GetPropertyValue("Trustee"), ManagementBaseObject).Properties("Domain").Value IsNot Nothing Then
I'm trying to access a database (SQL Server 2008 express) using Visual Basic 2010 Express. First I got a permission error that was solved modifying the Database permissions. Now I get a new error message "This file is in use. Enter a new name .." I already have changed the Autoclose propertie to true, and also tried detaching the Database.
I'm using Windows Vista Home Premium, my string: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQL10MSSQLDATAemplo1.mdf"; Integrated Security=True; Connect Timeout=30; User Instance=True
I have a TextBox, and I want to force the user to type an email format in this field like ([URL]) ? I don't want to use FilteredTextBoxExtender or the RegularExpressionValidator. I want to do it manualy.
I was wondering if somone one could point me in the right direction on this.Basically I am making a proxy testing program. A user can supply a list of proxies to test. What i want to be able to do is have them be able to specify how many threads they want to run. Then have the program go through the list testing each one using the amount of threads supplied. Really not sure even where to start on this. Threadpooling?
What is the best way to easily switch from a test database to a production database in vb.net and MySql, when all MySql connection strings are currently hard coded?
I have a combo box and use the SelectedIndexChanged event. I noticed when I assign a value to the combo box that this event fires even though the user does not click on the control. Can you tell me how to test for when the user clicks on it and actually selects a value from it?
I need a simple snippet that will allow the user to test the connection for the FTP server entered in a textbox and the username and password from 2 other textboxes. (Server = TextBox1.Text, U/N TextBox2.Text, PW TextBox3.Text) I forgot to note something obvious - there's a "Test FTP" button
I am using VB 2008 Express and have created an application that connects to a SQL database to populate a datagrid.The application is working properly on my computer but will not on others 'remote connection permissions' error.After some googleing I found that the express version is crippled to only work on local machines that use a database.If I purchase Visual Studio 2008 Standard Edition, import and rebuild my application, will my application be able to run properly on other PC's?
I am a new user to VB and I am having difficulty with one of my assignments. The assignment states that to create an application that allows a user to enter three test scores each for three students. The application should calculate each student's average test score and assign a letter grade. The application should prompt the user for each student's name and three test scores.
I'm trying to test/debug a WPF UserControl library in Visual Studio 2010 with the User Control Test Container.exe. I keep getting the error "Assembly [...] doesn't contain any UserControls." This should be simple, and every msdn article and blog tutorial I've looked at suggests that it should all just work perfectly and magically.[code]Project File has debug options set to open UserControlTestContainer.exe, with ./MyTestLibrary.dll as a command-line arg.
I have to write a program for a user to take a 20 question test (A, B, C, D). The users answers will be stored in an array and compared with a 2nd array that has the correct answers. Its then supposed to go to a 2nd form when you click show score, grade it, and display whether each answer was right or wrong. I'm missing something easy probably.
I'm not sure where I'm going wrong with this. it's supposed to let the user add scores to the list, then calculate the total, average, and count. However, it doesn't let me add more values to the list. Any help whatsoever would be awesome! Keep in mind, I am new to VB and programming languages, and was just playing around with code hoping for any sort of positive result, and therefore some of the code may not be necessary, or make sense. Here's what I have now:
i am trying to make a simple Vb program for children to do simple maths, now im not sure im going about it the right way, i have stored all the questions in a database and have called them up to the form and that is working fine, i cant seem to get the right code to check the answer from the user against my stored answer, i am using txtBox to store my answer and a txtbox for the input
On an xp system using VB 2008 exprees, I'm trying to write code which will change a file's permisions when run from a non admin account. To do this I need to now how to run the code as an administrator. I've got the code to change permissions working, I just don't know how to run it with an administrator's credentials. The code is:
Imports System.IO Imports System.Security.AccessControl Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Create a program which promps the user to enter an unlimited number of test scores. The program should show the high score and the low score. You should use a loop of your choice within this program. The program should look similar to the one below:
I am looking for a simple code example that will test to determine if the database first is empty before attempting the Item() command.With the above example, the Item() line produces the error "Conversion from type 'DBNull' to type 'Integer' is not valid." for an empty database.
I am new to Visual basic and am using visual basic 2008 to write programs in, I have setup a database connection and the connection string is currently stored in the settings section of the project.I would like to have a menu item where when the user selects "test database connection" it will run the sub for testing if the database is established.
I have a text box which I'm saving to a database. Before doing a addnew which add a line to the database with a Id number and a blank item, I wish to test the textbox for actualentry before. Here's code I'm tryin
I am having a problem with a unit test I have created. First time doing this so I am not sure why I am getting this error [code]Test method ETDS_Unit_Tests.LoginTest.ValidateUserNameTest threw exception: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).This is the same connection that my software is using, and the software runs fine, only the unit test is failing. What I am doing wrong? It Seems to fail one time for each datarow in the table.Also, I am using a Linq Query in the method that I being tested. I believe that this may be what is causing my error.
