user-permissions

Allowing a user to only backup and restore in Sql Server 2008

I am using Sql Server 2008 and would like to create a user login that can only have a readonly view of the data, create backups and restore the database. The first two I can do fine, using db_datareader, db_datadenywriter and db_backupoperator. I have problems with the restore however. From what I have read, you have to make the user ...

User permissions Django for serving media

Hey, I want to set up a Django server that allows certain users to access certain media. I'm sure this can't be that hard to do and I'm just being a little bit silly. For example I want USER1 to be able to access JPEG1, JPEG2 and JPEG3 but not JPEG4, and USER2 to be able to access JPEG3 and JPEG 4. [I know I should be burnt with fire ...

Runtime Error '3709' while accesing SQL database in VB6

I have a VB6 application which someone wrote, which does not work for only some users who try to use it. This is the code running which returns an error: On Error GOTO error_handler .. Set db = New ADODB.Connection db.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=****;Password=****; Initial Catalog=***;Data Source=*...

Users have "read" access to Sharepoint site even when all user permissions were removed.

I have a Sharepoint site (MOSS 2007 SP2) that all domain users seem to have read access to even if I remove all user permissions to the site. I have no problem granting users all levels of permissions. For example, I can grant userA full access to my site, but when I remove the user completely from the site they still have read access. ...