ProjectServer

Because PSI cannot be used,  we have to retrieve users permissions  directly from DB. At first  we have to find location of Project Server databases.

    public class ProjectInfo

    {

        private string _csPublished;

        private string _csWorking;

        private string _csVersions;

        private string _csReporting;

        private string _sspURL;

        public string sspURL

        {

            get { return _sspURL; }

            set { }

        }

        public string ConnectionStringPublished

        {

            get { return _csPublished; }

            set { }

        }

        public string ConnectionStringWorking

        {

            get { return _csWorking; }

            set { }

        }

        public string ConnectionStringVersions

        {

            get { return _csVersions; }

            set { }

        }

        public string ConnectionStringReporting

        {

            get { return _csReporting; }

            set { }

        }

        public ProjectInfo(SPSite pwaSite)

        {

            ReadInfo(pwaSite.ID, pwaSite.WebApplication.Id);

        }

        private ProjectInfo(Guid pwaUID)

        {

            Guid AppUID;

            using (SPSite sitePWA = new SPSite(pwaUID))

            {

                AppUID = sitePWA.WebApplication.Id;

                ReadInfo(pwaUID, AppUID);

            }

        }

        private void ReadInfo(Guid pwaUID, Guid AppUID)

        {

            ServerContext sc = ServerContext.Default;

            object serverFarm = sc.GetType().GetField("m_ServerFarm", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(sc);

            //Use reflection to get the ShareResourceProviders collection

            object sharedResourceProviders = serverFarm.GetType().GetProperty("SharedResourceProviders").GetValue(serverFarm, null);

            //Enumerate all Shared Service providers

            foreach (object sharedResourceProvider in sharedResourceProviders as IEnumerable)

            {

                object WebApps = sharedResourceProvider.GetType().GetProperty("WebApplications").GetValue(sharedResourceProvider, null);

                foreach (object webApp in WebApps as IEnumerable)

                {

                    if ((Guid)webApp.GetType().GetProperty("Id").GetValue(webApp, null) == AppUID)

                    {

                        Guid sspGuid = (Guid)(sharedResourceProvider.GetType().GetProperty("AdministrationSiteId" /* "ApplicationId"*/).GetValue(sharedResourceProvider, null));

                        string sspName = sharedResourceProvider.GetType().GetProperty("Name").GetValue(sharedResourceProvider, null).ToString();

                        bool sspSSL = (bool)sharedResourceProvider.GetType().GetProperty("UseHttpsForWebServices").GetValue(sharedResourceProvider, null);

                        using (SPSite sspSite = new SPSite(sspGuid))

                        {

                            if (sspSSL)

                            {

                                _sspURL = string.Format("https://{0}:56738/{1}", sspSite.HostName, sspName);

                            }

                            else

                            {

                                _sspURL = string.Format("http://{0}:56737/{1}", sspSite.HostName, sspName);

                            }

                        }

                    };

                }

                object SharedApplications = sharedResourceProvider.GetType().GetProperty("SharedApplications").GetValue(sharedResourceProvider, null);

                foreach (object sharedApplication in SharedApplications as IEnumerable)

                {

                    if (sharedApplication.GetType().FullName == "Microsoft.Office.Project.Server.Administration.ProjectPSISharedApplication")

                    {

                        object ProvisionSettingsCollection = sharedApplication.GetType().GetProperty("SiteCollection" /*"ProvisionSettingsCollection"*/).GetValue(sharedApplication, null);

                        foreach (object ProvisionSettings in ProvisionSettingsCollection as IEnumerable)

                        {

                            Guid SiteID = (Guid)GetProperty(ProvisionSettings, "SiteId");

                            if (SiteID == pwaUID)

                            {

                                _csPublished = (String)GetProperty(GetProperty(ProvisionSettings, "PublishedDatabase"), "DatabaseConnectionString");

                                _csReporting = (String)GetProperty(GetProperty(ProvisionSettings, "ReportingDatabase"), "DatabaseConnectionString");

                                _csVersions = (String)GetProperty(GetProperty(ProvisionSettings, "VersionsDatabase"), "DatabaseConnectionString");

                                _csWorking = (String)GetProperty(GetProperty(ProvisionSettings, "WorkingDatabase"), "DatabaseConnectionString");

                                return;

                            }

                        }

                    }

                }

            }

        }

        private static object GetProperty(object obj, string property)

        {

            return obj.GetType().GetProperty(property).GetValue(obj, null);

        }

    }

Now we have DB connection string we can work directly with Project Database,

On project server PWA application pool sending all request to SSP so we have 2 option create custom Psi web service in SSP or grant  PWA application pool account access to  project server Published database.

SQL queries.

1)st  we need list of Global permission it the same list which is returned by PSI

Security.ReadOrganizationalPermissions();

SELECT     TOP (100) PERCENT dbo.MSP_WEB_CONVERSIONS.CONV_STRING, dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_FEA_ACT_UID                                        

                     FROM         dbo.MSP_WEB_CONVERSIONS WITH (NOLOCK) INNER JOIN

                                           dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS WITH (NOLOCK) ON

                                           dbo.MSP_WEB_CONVERSIONS.CONV_VALUE = dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_FEA_ACT_NAME_ID

                     WHERE     (dbo.MSP_WEB_CONVERSIONS.STRING_TYPE_UID = '{946E9CC0-ED95-4F6F-877F-9A9ADAB57929}') AND

                                           (dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_ON_OBJECT = 0) AND

                                           (dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_IS_ACTION = 1) AND

                                           (dbo.MSP_WEB_CONVERSIONS.LANG_ID=1033)

                     ORDER BY dbo.MSP_WEB_SECURITY_FEATURES_ACTIONS.WSEC_FEA_ACT_NAME_ID