I want to add users in same role in more than one database. However the role can/cannot be present in all the database. How can i check if the role exists in database and if it does add users in that role? e.g. IF role exists BEGIN Add user in role END ...
I'm adding WMI publishing to a .net framework 3.5 based windows service that is running under the 'network service' account. According to a document I came across on MSDN, the 'network service' account should by default have WMI publishing permissions. ("By default, the following users and groups are allowed to publish data and events: ...
I'm trying to secure an MS Access 2003 mdb using the workgroup security. I've got most of it set up (using a new MDW etc), but I can't stop people creating new tables in the database, if they've got access to open it. Am I missing something? None of the accounts have any permissions allowed, I'm doing it all through groups. Users only ...
I'm using Sql Server 2008 and have a proc that uses sp_executesql inside. I keep getting the following error when executing the proc through ASP.NET: The SELECT permission was denied on the object 'MyTable', database 'MyDatabase', schema 'dbo'. I've done lots of research on this and most people point to the fact that I need to grant se...
Trying to version control my project that's sitting in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs using TortoiseSVN. I can't commit it though because Tortoise doesn't have permission to create the .svn file in that folder (anywhere in Program Files?). How can I get around this? ...
I've been using SVN to track my projects, and I've run into a problem several times. svn: Directory "/programming/projects/mydirectory" containing working copy admin area is missing I bet you're familiar with that one. What seems to be making this happen is when I try to "svn add" a directory that I don't have write permission to....
Ok so I'm using ASP.NET MVC. I'm supposed to upload a file and write it to a network share. I'm getting "Logon failure: unknown user name or bad password." when I try to write to the network location. I solved it on my machine by impersonating the file server account, added this to web.config: <identity impersonate="true" userName="xx...
I have a Drupal site that is available at two different hostnames, one of which is only served using SSL. For example, http:// www.example.com is for viewing content and https:// manage.example.com is used by content contributors. I would like to configure Drupal to not show content through the https:// manage.example.com address unles...
I have an installer written in Java using Izpack. It works OK on Windows XP, however on Windows 7 it cannot write to c:\Program Files. Strangely enough, as a user running this installer I can create folders under c:\program files, but not from the installer itself. What am I missing ? ...
Inspired by various schema related questions I've seen... Ownership chaining allows me to GRANT EXECUTE on a stored procedure without explicit permissions on tables I use, if both stored procedure and tables are in the same schema. If we use separate schemas then I'd have to explicitly GRANT XXX on the the different-schema tables. The ...
I'm doing a Facebook Connect integration for a site and when the user logs in, I need to ask for some permissions so I use FB.Connect.showPermissionDialog. I use its callback to see if permissions were granted. If they are granted, I want to submit the form. Here's what my code looks like: $("#form3").live("submit", function() { FB.Co...
Hi Everybody.. I started a Silverlight project in VS2010 Beta 2. Using parallels on my Mac and I´ve added this to the Web.Config to compile succesfully: <runtime> <loadFromRemoteSources enabled="true"/> </runtime> But the page loads with this Error and I searched a lot without success: Server Error in '/' Application. Configuration...
Can anyone suggest a scalable design pattern for implementing access control on Photos and Albums, each with individual privacy settings (i.e. owner, group member, public)? I'm using CakePHP, and the examples I have read on the ACL component seem to control access to controller/actions, not objects themselves. It seems to get out of ha...
I have come into the habit of hand-sketching various diagrams for software I create. My software is mostly for the web. I use E-R diagramming for the data logic (model of MVC) , and a personally invented diagram style for the interactions -- what pages lead to which other ones and what do they do, i.e. the views & controllers of MVC. Th...
Hi, We have a requirement where we need to check if a user has "Upload" access to a folder in Sharepoint document library. For that, I am using the "GetPermissionCollection" method of Permissions webservice on the document library. The response I get is of below format: I am not able to convert the Permission mask to role. I am doing...
i have to admit, i never really completely got the *nix filesystem permission model. oh, the rwxrwxrwx stuff isn't too complicated, but i get confused easily when programs create new files and how i can handle them. my current problem is the mixture of a (closed source) java-applet that does file uploads over ftp and php (it's on a ded...
Trying to print an ASP.NET Charting control behind the scenes in my web app. I think it is a permissions issue with the printer as everything is ok up until the point where my code calls: chart.Printing.Print(false); bool finished = false; while (!finished) { finished = File.Exists(settings.GetValue("statusfile")); // file which ind...
Some users are committing svn deletes by mistake, and I would like to restrict these accidental deletes, while retaining read/write permissions. Of course, they could overwrite files with zeros, but that doesn't accidentally. I did some googling and found there was a python file that claimed to do this, but as svn has changed sites, the ...
Hi, Is there any permission or grant command on a table which make users not able to delete records (row) that inserted by another user. But allow them to delete or update their own record? Thanks, Stephen ...
Hi, I am trying to use apache to access a XML from tomcat url like so: http://localhost:8081/solr-example/select/?q=blah&version=2.2&start=0&rows=10&indent=on However, I am getting a permission denied error. I have tried chown, chmod and chcon on both the tomcat and solr directories and it still gives me the error. I a...