Users Should Not Have Access To SQL Server
Apr 13, 2010
Is it feasible to deploy a VB.NET windows forms application with a SQL Server back end where no users have direct access to SQL Server? The idea is that there is no way someone at the client site with admin capabilities could mess up the data definition, or directly alter data. I always assumed that somebody with the client should get admin capabilities, but perhaps not.
The application will have to have the capability of creating logins, doing backups, perhaps running scripts (encrypted?) For upgrades, and whatever else a user with elevated privileges would do. I guess the application would have a hard-coded account with admin privileges for this purpose. Is this a common way to deploy an application? The application uses SQL Server Express, which is installed with the application. The database will be installed with the application.
View 2 Replies
ADVERTISEMENT
Dec 30, 2009
So I'm creating this app that will install SQL server 2008 express, add some SQL users and then import a database.
Is there a way to create users for SQL express in Vb.net?
View 1 Replies
Jan 25, 2010
How to read users in sql server in vb .net. i want to synchronise users from sql with users from my application.
View 2 Replies
Aug 6, 2009
is there a way for a program to get a list of users that are logged into the terminal server that it is running on???
View 3 Replies
Apr 21, 2012
I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber. I am using VS2010/VB.NET/ASP.NET.
View 1 Replies
May 17, 2012
I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber.
View 2 Replies
Aug 3, 2010
I am trying to develop a small application that logs the IP address and or computer names of all the users [my domain or remote location] that accessed files or folders on the server.
View 1 Replies
Mar 21, 2012
i need to get users domain from any server and fill my combobox.[code]
View 3 Replies
May 29, 2009
using the sql server management studio we can create users to access the database. so we can grant several privileges as well as revoke some. so i want to create a login form with those user's. how to do it. is there any other way [code] in the connection i have to mention the user also.. is it possible. if its possible.
View 1 Replies
Oct 26, 2009
is there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 Replies
Feb 23, 2012
For example, a user logs in and sets his status in SQL Server to active. While using the program, it suddenly blacks out. The status in SQL Server remains active. When the user logs in again, he can't access the same account in the program because in SQL Server the status remains active. How can I set the status to inactive during blackouts?
View 1 Replies
Apr 8, 2012
how to authenticate users with the SQL Server database table using VB as a web service. I managed to connect to the SQL server via this VB code;
Public Sub ConnectToSQL()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[Code].....
View 1 Replies
Dec 11, 2009
I am trying to write VB Code that would allow me to access a users cookies from their PC. Is their any code snippits that any of
View 2 Replies
Feb 15, 2011
I am building a simple intranet site and want to get the employees user name, but when i use Request.LogonUserIdentity.Name , i keep getting the servers credentials and not the users. what am i doing wrong and is there a better way to do this.
View 1 Replies
Oct 4, 2009
Im trying to make my client send the users Account and IP to the server. And the server puts them on a list box?
View 3 Replies
Mar 23, 2012
Looking for some .net snippet on accessing what users are logged into a domain. I have looked through all the AD namespace and okay with that in getting static items. Specifically, NOT looking for current logged in user for a given machine(have that as well). Looking for a list of users that are currently signed into a Domain.Essentially, I want to pass a user (or list of users) to a method that will check to see if the user passed in, is currently logged into the network (AD).
View 6 Replies
Apr 30, 2012
I know my Question was asked maybe 10000 times before, but i really did not take the chance to search the forum coz i really short of time.
I have *.mdb DataBase with 20 tables each table have more than 10 fields, i'm trying to automate the MDB file from a network like that 5 PCS + One vb.net exe program (5 users) working on the same time on the exe that is connected to the database , my questions are :
1) How much risk is it to put the database into one (shared) folder and connect it to the program ?
2) What is the best way to establish this method ?
3) Is there any alternatives ?
View 4 Replies
Nov 23, 2011
I'm trying to collect directories and add to TreeView. In Windows 7, there is a "Documents" folder under Libraries which is basically linked to "My Documents" under "Users". When I click "Documents" in the TreeView, I can get a list of all subdirectories by using
Dim dirs As String() = Directory.GetDirectories(strDir)
View 3 Replies
Jun 21, 2010
i'm developing an application with vb.net and mysql. I want to add additional users to the application but with different access levels. this is my original code [code]If i add a third parameter named level to the sql statement, how do i determine which form shows???
View 3 Replies
Feb 26, 2010
I'm trying to return from a webpage, the remote HKCUVolatileCLIENTNAMEHere's what I'm doing so far:
Get the Machine Name via DNS - this bit works great:
Public Shared FunctionGetMachineName(ByVal String
[code].....
View 2 Replies
Apr 18, 2010
This program is going to submit GET data to our webpage. However, we don't want users accessing the webpage any other way than the program. We can prevent users from sharing the program using HWID authentication, but nothing prevents them from using a packet scanner to get the URL of the webpage. We thought about user-agent authentication, which we will implement, but user-agents can easily be spoofed.
how can we prevent users from accessing the webpage directly, instead of through the program?
Currently we will be implementing:
HWID Authentication to use the program User-Agent Authentication to access the web page Instant IP Blacklisting to anyone accessing the webpage without the proper User-Agent
View 4 Replies
Jan 20, 2009
In my application, I create data and log folders that must be shared by all users using this computer. I did a lot of research, and I found a function that is supposed to grant full access to every users of a folder and its children. However if right-click properties on my folder, the access is unchanged. ow should I grant full access to all users of a folder and its children (I don't care who created it, all users should be able to read and write to that folder)?
Public Sub GrantAllAccess(ByVal Folder As String)
Try
Dim DomainUser As String = Environment.UserDomainName & "" & Environment.UserName
[code].....
View 5 Replies
Aug 22, 2008
I am developing an access database that will be shared with multiple users.I don't want the users to access the database directly so I will have them enter new data on a data access page. The data access page is stored on a Microsoft Share Point web page, and the database is stored on a network drive.Here is my problem: When new data is entered on the web page I need it to trigger a WillChangeRecordset event; however, I have not been successful because the web page does not declare a new instance of a recordset object.At a minimum I need the new data to be processed before the web page appends the new data to the table.
View 3 Replies
Nov 5, 2011
I am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?
View 2 Replies
Feb 24, 2011
I have a site where users must only be able to access the Login.aspx page via SSL/HTTPS.Currently I run something like the following in my Page_Load():
If Not (IsSSL) Then
Response.Redirect("https://" + thisDomainName + "/Login.aspx")
End If
Is there a better way of doing this?
View 2 Replies
Jun 22, 2012
I would like to give permission to use this project to say, 10 users. The following code is fine for a single user. How can I write conditional code to provide the access to other nine users?
Submit button
If txtUsername.Text <> "Mahajan" Or txtPassword.Text <> "mh745" Then
MsgBox "Access Denied! Either Username or Password is incorrect!", vbOKOnly + vbCritical, "Security Login"
txtUsername.Text = ""
txtPassword.Text = ""
[code]....
View 5 Replies
Oct 26, 2010
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Replies
Jun 8, 2012
I want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
View 2 Replies
Jul 6, 2010
I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
View 2 Replies
Feb 9, 2010
I have an asp.net web app that uses forms-based authentication, a SqlMembershipProvider (using an encrypted password format), and a SqlRoleProvider. I need to know if it's possible to administer the users (create new users, assign them to roles, etc.) from a windows application - the powers that be don't want any administrative functionality in the web app itself.Here is the membership provider definition from web.config:
<membership defaultProvider="MyProvider">
<providers>
<add name="MyProvider"
[code].....
View 3 Replies