java - SQL SERVER 2008-无法获取 ddl 架构中少数对象的对象定义？

Question

我正在使用MS SQL SERVER 2008数据库，在其中创建所有对象，例如过程、函数、 View 等。现在创建一个示例程序获取所有对象definition(ddl)，在这里我发现一些对象定义是null，我使用以下sql查询来获取所有过程的定义:

Select object_definition(object_id) from sys.objects where type = 'P'

这是我的示例代码:

public class sam {
    String userName;
    String dbURL;
    String password;

    public sam(String dbURL, String userName, String password) {
        this.dbURL = dbURL;
        this.userName = userName;
        this.password = password;
    }

    public void createSQLFile() throws IOException, SQLException, ClassNotFoundException {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection con = DriverManager.getConnection(dbURL, userName, password);
        Statement statement = con.createStatement();
        String queryString = "Select object_definition(object_id) from sys.objects where type = 'P'";
        ResultSet rs = statement.executeQuery(queryString);
        while (rs.next()) {
            System.out.println(rs.getString(1));
        }
    }

public static void main(String[] args) 抛出 SQLException、IOException、ClassNotFoundException {

    String dbURl = "jdbc:sqlserver://localhost:1433;DatabaseName=db";
    String userName = "u";
    String password = "P";
    new sam(dbURl, userName, password).createSQLFile();

}

}我还附上了我的数据库的屏幕截图，其中列出了程序(注意:突出显示的程序神化为空)。

任何人都可以建议-如何在加密时获取这些对象定义？

Answer 1

MSDN州

The definition of user objects is visible to the object owner or grantees that have any one of the following permissions:
ALTER,
CONTROL,
TAKE OWNERSHIP,
or VIEW DEFINITION.