1
  • Access rights for all user of an SQL SERVER 2005

    Hi all, have you an idea how can i export the list of users and there access rights of an SQL SERVER 2005; THANK YOU

    Backtrack85 pointsBadges:
  • Deny domain administrators to select from sql server tables ( SQL server 2005)

    I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group has local...

    IgorS5 pointsBadges:
  • Administrator privileges in SQL Server 2008

    I recently installed SQL Server 2008 R2 onto my local machine. However, I can't create a new database because I'm getting the following message:CREATE DATABASE PERMISSION DENIEDAfter I saw that message, I tried to switch my administrator privileges but I received this:"User does not have permission...

    ITKE352,570 pointsBadges:
  • Any unsurpassed method to start-off this procedure an appropriate

    I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require...

    KaziMamunur35 pointsBadges:
  • SQL Server 2005 permissions required by public

    Our security madates that ALL object permissions be removed from"public". After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?

    VelameLaCosa110 pointsBadges:
  • Kerberos unconstrained delegation for MS SQL svc account

    Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

    Calicdaj5 pointsBadges:
  • Permission to Export SQL Server 2005

    On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?

    VelameLaCosa110 pointsBadges:
  • Access Rights in SQL Server 2005

    Hi,  I'm using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the Tables created in my DB...pls provide me Step...

    ENGG66615 pointsBadges:
  • Migrate User & Permissions SQL 2000 to SQL XXXX

    Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

    Njimenez5 pointsBadges:
  • Configuring a password message prompt on SQL Server 2000

    On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Giving login and database permissions to a group in SQL Server 2005

    I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Password policies for SQL Server 2005 (Yukon)

    What are the password policies within SQL Server 2005 (Yukon)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Excluding Data Usin NOT IN

    I'm trying to export data from a sql table into sql reporter. The information I'm trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account...

    Jerzdevs10 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following