public override bool CheckPermission(TablePermission permission) { string query = @"SELECT COUNT(1) FROM USER_TAB_PRIVS WHERE TABLE_BAME = @tableName AND PRIVILEGE = @permission"; var permissionCmd = new OracleCommand(query); permissionCmd.Parameters.Add(new OracleParameter() { ParameterName = "@tableName", Value = permission.TableName }); permissionCmd.Parameters.Add(new OracleParameter() { ParameterName = "@permission", Value = permission.Permission.ToString() }); permissionCmd.Connection = _dbConnection as OracleConnection; var reader = permissionCmd.ExecuteReader(); reader.Read(); bool result = (int)reader[0] == 1; reader.Close(); return(result); }
public override bool CheckPermission(TablePermission permission) { string query = @"SELECT HAS_PERMS_BY_NAME (@tableName, 'OBJECT', @permission)"; var permissionCmd = new SqlCommand(query); permissionCmd.Parameters.Add(new SqlParameter() { ParameterName = "@tableName", Value = permission.TableName }); permissionCmd.Parameters.Add(new SqlParameter() { ParameterName = "@permission", Value = permission.Permission.ToString() }); permissionCmd.Connection = _dbConnection as SqlConnection; var reader = permissionCmd.ExecuteReader(); reader.Read(); bool result = (int)reader[0] == 1; reader.Close(); return(result); }
public abstract bool CheckPermission(TablePermission permission);