Hi All, I have a SQL Server 2000 database with around a couple of hundred tables. There are several SQL user accounts that can access this database but each one has different permissions granted on tables in the DB. How do I create a script to give me a report of the permissions granted to a particular user. i.e. to generate something...
In a database I am designing I have implemented profile based object level security. Each user can view, edit, insert, update database tables according to the profiles (roles) he is a member of. Now there is a need to implement "External Users" who can view only the relevant records and edit some of them (but not the bulk of the database...
Is there someway to set the default file permission in Linux? That is, the file permission for a newly created file (regardless of the context for which it was created ). I know about putting umask in the shell startup but that only works for shell sessions. When I transfer files to a Linux box using pscp, the file is always created with...
Hi. I am part of a team creating a web application using PHP and MySQL. The application will have multiple users with different roles. The application will also be used in a geographically distributed manner. Accordingly we need to create an access control system that operates at the following two levels: Controls user permissions fo...
Is there a way to unlock Windows files without downloading a utility? I have a few files on my Windows XP C: drive that are very old and very useless. When I try to delete these files I get the following message: Cannot delete FILENAME.zip: It is being used by another person or program Close any programs that might be using the file...
I'm trying to delete a directory that contains XML files from a remote computer. My code compiles and runs fine, but when I go to get a list of XML files in the path I specify, it is not returning anything. Am I missing something permission wise? I have ran it from my computer logged on as myself and from another computer logged on as a ...
I've been exploring the details of Django for about a week now and like what I see. However I've come upon some.. negativity in relation to fine-grained control of permissions to the CRUD interface. What I'm writing is an Intranet client management web-app. The organisation is about 6 tiers, and I need to restrict access to client group...
In SQL Server 2005, I want a user, called LimitedUser, to only be able to run one proc: GRANT EXEC ON [usp_RunETL] TO [LimitedUser] However, that proc needs to be able to do everything -- UPDATE, DELETE, INSERT, EXEC.. everything. How do I do that without having to give all those permissions to LimitedUser? ...
For the sake of simplicity: There is a permission based system in place with different kinds of user levels and actions (think: UNIX file system permissions) What would be the best approach to visualize this in UML? ...
If I have "Full Control" permission on a list, is there a way for me to see all the individuals who have an alert set for that list? Some people in my department are better at managing their own subscriptions than others, and this is a question I have received from several team leads. They want to be able to see and confirm who has ale...
In our Sharepoint implementation users have been granted site collection admin rights. On a few occasions they've managed to delete a subsite or even the entire site collection. I'd like to be able to block this but not being a developer I'm finding it pretty tricky. I've had a look at the MSIT site delete capture tool to try to underst...
I'm debating the best way to propagate fairly complex permissions from the server to an AJAX application, and I'm not sure the best approach to take. Essentially, I want my permissions to be defined so I can request a whole set of permissions in one shot, and adjust the UI as appropriate (the UI changes can be as low level as disabling ...
Here is my situation: I know almost nothing about Perl but it is the only language available on a porting machine. I only have permissions to write in my local work area and not the Perl install location. I need to use the Parallel::ForkManager Perl module from CPAN How do I use this Parallel::ForkManager without doing a central instal...
When I try to commit the first revision to my git repository (git commit) from Cygwin, I'm getting an error in gvim which says "Unable to open swap file for "foo\.git\COMMIT_EDITMSG" [New Directory]. I think it might be some sort of permission problem, but I've tried removing the read-only flag from the folder, as well as recursively adj...
In a list where items only can be changed by owner or admin how can I check by code if a user can edit the item. I try item.DoesUserHavePermissions(SPBasePermissions.EditListItems); it will return True as the user can add and edit items in list. ...
I'm trying to use NAnt/NAntContrib build script to build a web application on Windows 2008 (IIS 7.0). In the build file, there is mkiisdir task, which fails with: [mkiisdir] The webservice at 'localhost' does not exist or is not reachable. All the documents/posts I found so far (non for w2k8, only Vista) say to install IIS 6 Compatibi...
I'm having trouble with SQL Server 2008 (Express with Advanced Services) Reporting Services permissions. I'm running this on Vista Ultimate at home - standalone machine with no servers, no domain or active directory. When I go to the ReportServices site, I get this: The permissions granted to user 'localmachine\Scott' are insuffi...
Is it possible to create a user with permissions of both a local administrator and NETWORK SERVICE? I've got a Sharepoint timer job which runs stsadm for which it needs local administrator permissions. On the other hand temer jobs are also used by other services which need NETWORK SERVICE permissions and those to sets of permissions onl...
Hi, We've just moved our website to win2008 and IIS7 from win2000 with IS5 and I have some problems. I have a folder that in it is an ASP page that upload a file to an upper folder, in the old IIS, I gave to the folder with the ASP page the permissions of the administrator and it's work fine, the files could be uploaded to an upper fol...
I have a local user, which is member of Administrators local group. When I run this code: using System; using System.DirectoryServices; namespace nanttest { class Program { public static void Main(string[] args) { using(DirectoryEntry entry = new DirectoryEntry("IIS://localhost/W3SVC")) { object ab...