SQL Server :: Setting Permissions For Website Visitors?
Sep 14, 2010
I have my SqlServer 2005 database at a web host. I recently figured out how to set permissions for the stored procedures (see this link if you face the same problem:
[URL]
Now I wonder: What permissions should I give the website's visitors?
In a stored procedure's Properties window, I have three availabale users, the db owner (the db name), "guest" and "public". My bet is on public.
As far as permission types go, I hev the following available:
Alter, Control, Execute, Take Ownership, and View Definition. My guess is that the one of interest is Execute, correct?
In other words, should I set all stored procedures to Execute for public (not that I seem to have the permission to do that myself - I get an error message when I try to alter them)? If so, could I ask the web host to set them globally for me? Or should I only set stored procedure using UPDATE/INSERT/DELETE to Execute?
View 4 Replies
Similar Messages:
Sep 8, 2010
I have just succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db.
Now, I get the dreaded
The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'.
error. I can't set the permissions from within Visual Studio, can I?
What should I ask the web host to do?
a) Should I ask them to globally set execute permission on ...?
b) Should I ask them to set execute permissions to ... for only INSERT/DELETE/UPDATE stored procedures?
c) Should I ask them nothing, and handle this myself? If so, then how? And, the question remains, should I set execute permissions globally or on a per stored proc basis? And what's the name of the user who needs the property set correctly?
The reason why I ask these questionsis that I used to work with winfomrs at a university. There people should have different permissions depending on what group of users they belonged to.
View 4 Replies
May 13, 2010
I am interesting on log down the recent 100 visitors around the world whom have visited to my website and display their country information and IP address on the website developed by Silverlight platform.
Where can I get accurate data for detecting the visitors' IP address and geo-location information?
View 2 Replies
Mar 11, 2011
We are looking to create a website that displays information to all new visitors to a site, i.e. welcome,The big problem is that our website is not allowed to use long-lasting cookies (i.e. over 20 minutes). Does anybody know of any way we can determine whether a user has visited the site before or not. As another restriction, we can not add anyform of registration to the system. The application is being created in ASP.Net 3.5.
View 6 Replies
Sep 27, 2011
I just created a download counter on my website that increments when a download link is clicked. It also records the times of the downloads in a database. Along with that I was wondering if I could gather some general information about location of the visitor to my website that clicked the download link. Is there a way to do that? Maybe you're not supposed to try to get overly specific data because that would be a sort of invasion of privacy but if I could collect something that would tell me an approximate location of the visitor to my website that clicked the download link that would be nice if that can be gotten without too much trouble.
View 7 Replies
Aug 17, 2010
I need to show the number of online visitors and all visitors in my website. I use below code in global.asax file. But I thinks it is not a right way because I have seen false result for online visitors in my website.
Codes:
void Session_Start(object sender, EventArgs e)
{
Application.Lock();
Application["OnlineUsers"] = (int)Application["OnlineUsers"] + 1;
Application.UnLock();
System.Data.SqlClient.SqlConnection cn = new
[Code]....
View 4 Replies
Sep 3, 2013
How can I allow my website visitors to create text files in ASP.NET?
View 2 Replies
Jul 17, 2015
I have a scenerio like i have a website where by visitors comes in like you have aspforum.net. I want following:
1. when user visit on my site a cookie or script generate on the user machine
2. then if user is searching for shoes, books, or any thing that data should come on my server database so i can trace what is user behavior and likes and dislike.
How can i achieve it...
View 1 Replies
Jul 24, 2012
How to use the session and application variable in our website? And if we want to count the visitors of our website then how it will possible.
View 1 Replies
Jun 16, 2015
How to count the no. of visitors based on ip address using c# and mysql?
View 1 Replies
May 7, 2015
How to authenticate the visitors on my website using facebook authentication but when user logged on my website through facebook authentication at the same time visitors username, password and email must be registered with my database as well, so next time user can logged in through facebook authentication or through my website username and password as well.
View 1 Replies
Feb 24, 2011
If my application URL is this:
http://localhost:51422/MyApp/Pages/FormView.aspx
I want 2 things:
1- I don't want any people to delete "...../FormView.aspx" and go to this[URL] and browse the directory pages and folders names.
2- If anybody tired that, the application should redirect him to login page or home page.
View 5 Replies
Oct 7, 2010
I've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server. What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITYNETWORK SERVICE permission to my database? Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
View 1 Replies
Jan 5, 2011
How to add code to know visitors count and online visitors count ?
is there a good control or code ?
I use ASP.Net, C#.Net ad SQL Server
View 5 Replies
Dec 19, 2010
I have a site on domain1. I need to open a ModalDialog with a Page on domain2. My Domain2 is protected not to allow anonymous access so i get a login window like:
My problem is, for this one functionality, i want users to be able to see that ASPX, through the ModalDialog, without authenticating.
I tried using the ftp way:(URL)
and i get a javascript error.
My site is hosted in IIS6, Windows Server 2003 and i have full access to the server.
View 1 Replies
Sep 15, 2010
what permissions should we grant to the sql login for entity framework?
View 1 Replies
Jul 7, 2010
I am running a web-site with simple .aspx files on a standalone workgroup Windows Server 2008 called 'Max'.I had assumed that the .aspx files were accessed by the 'Network Service' account.The application pool for the website is running with 'Network Service' as the process account.I was puzzled, since 'Network Service' had no permission on these files. So I added event level auditing to the files, and I was suprised to learn that the .aspx files were being accessed by an account called Max$ (ie the computer account).this correct ?Why is the Network Service account not being used ??
View 3 Replies
Oct 25, 2010
I'm using VS2010 and need to give my remote server asp .net account (IUSR_istereos) access to my local intpub folder
how do I do that?
View 5 Replies
Mar 14, 2011
I'm looking to create a log-in feature so users can create their own profiles on the website. I don't know the first thing about setting it up... Databases, login controls, etc... This is my first time using ASP.net but I am a fast learner. I really need to have this feature set up tonight if possible.
View 2 Replies
Oct 15, 2010
I'm working with ASP.Net web services and am having a problem with a long-running process that takes about 5 minutes to complete, and it's timing out. To fix this, I was able to set the executionTimeout on the server's web.config to 10 minutes, and then set the .Timeout property on the Web Service object to approximately 9 minutes. Now, I'm worried that this may possibly cause some other web service calls to sit there for 10 minutes before they time out rather than the previous 90-100 seconds. I know the default on the client side is 100 seconds, but wasn't sure if updating the server's timeout setting would affect this.
Bottom line is - Is it safe to update the server's timeout setting to a long amount like 10 minutes, and rely on the default timeout on the client, or could this end up causing some problems?
View 1 Replies
Dec 22, 2010
Our site as it exists now utilizes only the bin file. We are going to re-migrate our site to use the .cs files to compile on the fly. What settings do I need to set to allow for this and what disadvantages if any are there for using the .cs files in prod?
View 3 Replies
Aug 16, 2010
Visual Web Developer 2008 Express. Visual Basic.
I have been asked to setup RSS Fed capability on the web site I am designing. I guess that we want to notify folks when articles or content changes on the site. I have posted in beginners since I am new to using RSS feeds.
1. How can I allow visitors to my site to "sign up" for RSS feeds?
2. How can I generate a "feed" programmatically so that it is sent to those who signed up for RSS feeds?
3. If my questions indicate a fundamental misunderstanding of what RSS is.
View 2 Replies
Mar 28, 2011
I setup the project on the network instead of localhost? I want to setup a Remote Site, I think is the lingo Go into visual studio File, open website and put the website name in the box and a password to open the source.Create a unique url name like myWebApp.mycompany.com
When I create a new website application in visual studio. When I am ready to debug Visual Studio sets all this up for me and it runs on local host automatically.I guess in my scenario I gotta set it up manually. How do I accomplish this?I created a new virtual directory, went through the permissions wizard and keep getting this error:
Failed to access IIS metabase.
View 2 Replies
May 9, 2012
I've designed and built this form using Visual Studio 2010 in design mode and set the appropriate controls for each function example txtemail for the text field. Here's a link to the form I did so far you may view my source code, the mission im trying to accomplish is to reset the form by clearing all fields and clearing all validations.
I'm currently studying the Asp.Net VB in TAFE too.
[URL] ....
View 6 Replies
Oct 26, 2013
I have a website solution where I have among other things some code for a photo album. I know wanted to make a separate website solution with only the photoalbum code. It is however giving me some issues with not finding files, which I believe are caused by not being able to set the virtual path in the website solution. The option is simply not present in the options as you can see on the image on the right.
View 3 Replies
